[Home] [Help]
View: HXT_ADD_ASSIGN_INFO_FMV
View Text
SELECT AAI.ROWID ROW_ID
, AAI.ID
, AAI.EFFECTIVE_START_DATE
, AAI.EFFECTIVE_END_DATE
, PEO.FULL_NAME
, AAI.ASSIGNMENT_ID
, ASG.ASSIGNMENT_NUMBER
, ASG.BUSINESS_GROUP_ID ASG_BUS_GRP_ID
, AAI.AUTOGEN_HOURS_YN
, HRLK.MEANING AUTOGEN_HOURS_YN_MEANING
, AAI.ROTATION_PLAN
, ROT.NAME ROTATION_PLAN_NAME
, AAI.EARNING_POLICY
, ERP.NAME EARNING_POLICY_NAME
, AAI.SHIFT_DIFFERENTIAL_POLICY
, SDP.NAME SHIFT_DIFFERENTIAL_POLICY_NAME
, AAI.HOUR_DEDUCTION_POLICY
, HDP.NAME HOUR_DEDUCTION_POLICY_NAME
, AAI.CREATED_BY
, AAI.CREATION_DATE
, AAI.LAST_UPDATE_DATE
, AAI.LAST_UPDATE_LOGIN
, AAI.LAST_UPDATED_BY
, AAI.ATTRIBUTE_CATEGORY
, AAI.ATTRIBUTE1
, AAI.ATTRIBUTE2
, AAI.ATTRIBUTE3
, AAI.ATTRIBUTE4
, AAI.ATTRIBUTE5
, AAI.ATTRIBUTE6
, AAI.ATTRIBUTE7
, AAI.ATTRIBUTE8
, AAI.ATTRIBUTE9
, AAI.ATTRIBUTE10
, AAI.ATTRIBUTE11
, AAI.ATTRIBUTE12
, AAI.ATTRIBUTE13
, AAI.ATTRIBUTE14
, AAI.ATTRIBUTE15
, AAI.ATTRIBUTE16
, AAI.ATTRIBUTE17
, AAI.ATTRIBUTE18
, AAI.ATTRIBUTE19
, AAI.ATTRIBUTE20
, AAI.ATTRIBUTE21
, AAI.ATTRIBUTE22
, AAI.ATTRIBUTE23
, AAI.ATTRIBUTE24
, AAI.ATTRIBUTE25
, AAI.ATTRIBUTE26
, AAI.ATTRIBUTE27
, AAI.ATTRIBUTE28
, AAI.ATTRIBUTE29
, AAI.ATTRIBUTE30
FROM HXT_HOUR_DEDUCT_POLICIES HDP
, HXT_SHIFT_DIFF_POLICIES SDP
, HXT_EARNING_POLICIES ERP
, HXT_ROTATION_PLANS ROT
, PER_PEOPLE_F PEO
, PER_ASSIGNMENTS_F ASG
, HR_LOOKUPS HRLK
, HXT_ADD_ASSIGN_INFO_F AAI
, FND_SESSIONS FSS
WHERE FSS.SESSION_ID = USERENV('SESSIONID')
AND FSS.EFFECTIVE_DATE BETWEEN AAI.EFFECTIVE_START_DATE
AND AAI.EFFECTIVE_END_DATE
AND AAI.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND FSS.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.PERSON_ID = PEO.PERSON_ID
AND FSS.EFFECTIVE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND AAI.AUTOGEN_HOURS_YN = HRLK.LOOKUP_CODE
AND HRLK.APPLICATION_ID = 800
AND HRLK.LOOKUP_TYPE = 'YES_NO'
AND AAI.ROTATION_PLAN = ROT.ID(+)
AND AAI.EARNING_POLICY = ERP.ID
AND AAI.SHIFT_DIFFERENTIAL_POLICY = SDP.ID(+)
AND AAI.HOUR_DEDUCTION_POLICY = HDP.ID(+)
Columns
| ROW_ID |
| ID |
| EFFECTIVE_START_DATE |
| EFFECTIVE_END_DATE |
| FULL_NAME |
| ASSIGNMENT_ID |
| ASSIGNMENT_NUMBER |
| ASG_BUS_GRP_ID |
| AUTOGEN_HOURS_YN |
| AUTOGEN_HOURS_YN_MEANING |
| ROTATION_PLAN |
| ROTATION_PLAN_NAME |
| EARNING_POLICY |
| EARNING_POLICY_NAME |
| SHIFT_DIFFERENTIAL_POLICY |
| SHIFT_DIFFERENTIAL_POLICY_NAME |
| HOUR_DEDUCTION_POLICY |
| HOUR_DEDUCTION_POLICY_NAME |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| LAST_UPDATED_BY |
| 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 |
| Name |
APPS.HXT_ADD_ASSIGN_INFO_FMV