PER_LOCATION_LEG

Details

Schema: FUSION
Object owner: PER
Object type: VIEW

Columns

Name
LOCATION_LEG_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE OBJECT_VERSION_NUMBER BUSINESS_GROUP_ID LEGISLATION_CODE LOCATION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 LLE_INFORMATION_CATEGORY LLE_INFORMATION1 LLE_INFORMATION2 LLE_INFORMATION3 LLE_INFORMATION4 LLE_INFORMATION5 LLE_INFORMATION6 LLE_INFORMATION7 LLE_INFORMATION8 LLE_INFORMATION9 LLE_INFORMATION10 LLE_INFORMATION11 LLE_INFORMATION12 LLE_INFORMATION13 LLE_INFORMATION14 LLE_INFORMATION15 LLE_INFORMATION16 LLE_INFORMATION17 LLE_INFORMATION18 LLE_INFORMATION19 LLE_INFORMATION20 LLE_INFORMATION21 LLE_INFORMATION22 LLE_INFORMATION23 LLE_INFORMATION24 LLE_INFORMATION25 LLE_INFORMATION26 LLE_INFORMATION27 LLE_INFORMATION28 LLE_INFORMATION29 LLE_INFORMATION30

Name

LOCATION_LEG_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

OBJECT_VERSION_NUMBER

BUSINESS_GROUP_ID

LEGISLATION_CODE

LOCATION_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

LLE_INFORMATION_CATEGORY

LLE_INFORMATION1

LLE_INFORMATION2

LLE_INFORMATION3

LLE_INFORMATION4

LLE_INFORMATION5

LLE_INFORMATION6

LLE_INFORMATION7

LLE_INFORMATION8

LLE_INFORMATION9

LLE_INFORMATION10

LLE_INFORMATION11

LLE_INFORMATION12

LLE_INFORMATION13

LLE_INFORMATION14

LLE_INFORMATION15

LLE_INFORMATION16

LLE_INFORMATION17

LLE_INFORMATION18

LLE_INFORMATION19

LLE_INFORMATION20

LLE_INFORMATION21

LLE_INFORMATION22

LLE_INFORMATION23

LLE_INFORMATION24

LLE_INFORMATION25

LLE_INFORMATION26

LLE_INFORMATION27

LLE_INFORMATION28

LLE_INFORMATION29

LLE_INFORMATION30

Query

SQL_Statement
( SELECT "LOCATION_LEG_ID","EFFECTIVE_START_DATE","EFFECTIVE_END_DATE","OBJECT_VERSION_NUMBER","BUSINESS_GROUP_ID","LEGISLATION_CODE","LOCATION_ID","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","ATTRIBUTE16","ATTRIBUTE17","ATTRIBUTE18","ATTRIBUTE19","ATTRIBUTE20","ATTRIBUTE21","ATTRIBUTE22","ATTRIBUTE23","ATTRIBUTE24","ATTRIBUTE25","ATTRIBUTE26","ATTRIBUTE27","ATTRIBUTE28","ATTRIBUTE29","ATTRIBUTE30","LLE_INFORMATION_CATEGORY","LLE_INFORMATION1","LLE_INFORMATION2","LLE_INFORMATION3","LLE_INFORMATION4","LLE_INFORMATION5","LLE_INFORMATION6","LLE_INFORMATION7","LLE_INFORMATION8","LLE_INFORMATION9","LLE_INFORMATION10","LLE_INFORMATION11","LLE_INFORMATION12","LLE_INFORMATION13","LLE_INFORMATION14","LLE_INFORMATION15","LLE_INFORMATION16","LLE_INFORMATION17","LLE_INFORMATION18","LLE_INFORMATION19","LLE_INFORMATION20","LLE_INFORMATION21","LLE_INFORMATION22","LLE_INFORMATION23","LLE_INFORMATION24","LLE_INFORMATION25","LLE_INFORMATION26","LLE_INFORMATION27","LLE_INFORMATION28","LLE_INFORMATION29","LLE_INFORMATION30" FROM per_location_leg_f WHERE TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date )

SQL_Statement

(

SELECT "LOCATION_LEG_ID","EFFECTIVE_START_DATE","EFFECTIVE_END_DATE","OBJECT_VERSION_NUMBER","BUSINESS_GROUP_ID","LEGISLATION_CODE","LOCATION_ID","CREATED_BY","CREATION_DATE","LAST_UPDATED_BY","LAST_UPDATE_DATE","LAST_UPDATE_LOGIN","ATTRIBUTE_CATEGORY","ATTRIBUTE1","ATTRIBUTE2","ATTRIBUTE3","ATTRIBUTE4","ATTRIBUTE5","ATTRIBUTE6","ATTRIBUTE7","ATTRIBUTE8","ATTRIBUTE9","ATTRIBUTE10","ATTRIBUTE11","ATTRIBUTE12","ATTRIBUTE13","ATTRIBUTE14","ATTRIBUTE15","ATTRIBUTE16","ATTRIBUTE17","ATTRIBUTE18","ATTRIBUTE19","ATTRIBUTE20","ATTRIBUTE21","ATTRIBUTE22","ATTRIBUTE23","ATTRIBUTE24","ATTRIBUTE25","ATTRIBUTE26","ATTRIBUTE27","ATTRIBUTE28","ATTRIBUTE29","ATTRIBUTE30","LLE_INFORMATION_CATEGORY","LLE_INFORMATION1","LLE_INFORMATION2","LLE_INFORMATION3","LLE_INFORMATION4","LLE_INFORMATION5","LLE_INFORMATION6","LLE_INFORMATION7","LLE_INFORMATION8","LLE_INFORMATION9","LLE_INFORMATION10","LLE_INFORMATION11","LLE_INFORMATION12","LLE_INFORMATION13","LLE_INFORMATION14","LLE_INFORMATION15","LLE_INFORMATION16","LLE_INFORMATION17","LLE_INFORMATION18","LLE_INFORMATION19","LLE_INFORMATION20","LLE_INFORMATION21","LLE_INFORMATION22","LLE_INFORMATION23","LLE_INFORMATION24","LLE_INFORMATION25","LLE_INFORMATION26","LLE_INFORMATION27","LLE_INFORMATION28","LLE_INFORMATION29","LLE_INFORMATION30"

FROM per_location_leg_f

WHERE TRUNC(SYSDATE)

BETWEEN effective_start_date AND effective_end_date )