eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HXT_ADD_ASSIGN_INFO_FMV

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.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

Name
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