VIEW: APPS.PER_SECONDARY_ASS_STATUSES_V

Source

View Text - Preformatted

SELECT S.ROWID , S.SECONDARY_ASS_STATUS_ID , S.BUSINESS_GROUP_ID + 0 , S.ASSIGNMENT_ID , S.ASSIGNMENT_STATUS_TYPE_ID , NVL(AMDTL.USER_STATUS,TYPTL.USER_STATUS) , S.START_DATE , S.COMMENTS , S.END_DATE , S.REASON , EMP.MEANING , APL.MEANING ,CWK.MEANING , S.REQUEST_ID , S.PROGRAM_APPLICATION_ID , S.PROGRAM_ID , S.PROGRAM_UPDATE_DATE , S.ATTRIBUTE_CATEGORY , S.ATTRIBUTE1 , S.ATTRIBUTE2 , S.ATTRIBUTE3 , S.ATTRIBUTE4 , S.ATTRIBUTE5 , S.ATTRIBUTE6 , S.ATTRIBUTE7 , S.ATTRIBUTE8 , S.ATTRIBUTE9 , S.ATTRIBUTE10 , S.ATTRIBUTE11 , S.ATTRIBUTE12 , S.ATTRIBUTE13 , S.ATTRIBUTE14 , S.ATTRIBUTE15 , S.ATTRIBUTE16 , S.ATTRIBUTE17 , S.ATTRIBUTE18 , S.ATTRIBUTE19 , S.ATTRIBUTE20 , S.LAST_UPDATE_DATE , S.LAST_UPDATED_BY , S.LAST_UPDATE_LOGIN , S.CREATED_BY , S.CREATION_DATE FROM PER_SECONDARY_ASS_STATUSES S , PER_ASSIGNMENT_STATUS_TYPES TYP , PER_ASSIGNMENT_STATUS_TYPES_TL TYPTL , PER_ASS_STATUS_TYPE_AMENDS AMD , PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL , HR_LOOKUPS EMP , HR_LOOKUPS APL, HR_LOOKUPS CWK WHERE S.ASSIGNMENT_STATUS_TYPE_ID = TYP.ASSIGNMENT_STATUS_TYPE_ID AND S.ASSIGNMENT_STATUS_TYPE_ID = AMD.ASSIGNMENT_STATUS_TYPE_ID(+) AND S.BUSINESS_GROUP_ID + 0 = AMD.BUSINESS_GROUP_ID(+) + 0 AND TYP.PRIMARY_FLAG = 'S' AND S.REASON = EMP.LOOKUP_CODE(+) AND EMP.LOOKUP_TYPE(+) = 'EMP_SEC_ASSIGN_REASON' AND S.REASON = APL.LOOKUP_CODE(+) AND APL.LOOKUP_TYPE(+) = 'APL_SEC_ASSIGN_REASON' AND S.REASON = CWK.LOOKUP_CODE(+) AND CWK.LOOKUP_TYPE(+) = 'CWK_SEC_ASSIGN_REASON' AND TYP.assignment_status_type_id = TYPTL.assignment_status_type_id AND TYPTL.language = userenv('LANG') AND AMD.ass_status_type_amend_id = AMDTL.ass_status_type_amend_id (+) AND decode (AMDTL.ass_status_type_amend_id, null, '1',AMDTL.language) = decode (AMDTL.ass_status_type_amend_id, null, '1',userenv('LANG'))

View Text - HTML Formatted

SELECT S.ROWID
, S.SECONDARY_ASS_STATUS_ID
, S.BUSINESS_GROUP_ID + 0
, S.ASSIGNMENT_ID
, S.ASSIGNMENT_STATUS_TYPE_ID
, NVL(AMDTL.USER_STATUS
, TYPTL.USER_STATUS)
, S.START_DATE
, S.COMMENTS
, S.END_DATE
, S.REASON
, EMP.MEANING
, APL.MEANING
, CWK.MEANING
, S.REQUEST_ID
, S.PROGRAM_APPLICATION_ID
, S.PROGRAM_ID
, S.PROGRAM_UPDATE_DATE
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.ATTRIBUTE16
, S.ATTRIBUTE17
, S.ATTRIBUTE18
, S.ATTRIBUTE19
, S.ATTRIBUTE20
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.CREATED_BY
, S.CREATION_DATE
FROM PER_SECONDARY_ASS_STATUSES S
, PER_ASSIGNMENT_STATUS_TYPES TYP
, PER_ASSIGNMENT_STATUS_TYPES_TL TYPTL
, PER_ASS_STATUS_TYPE_AMENDS AMD
, PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
, HR_LOOKUPS EMP
, HR_LOOKUPS APL
, HR_LOOKUPS CWK
WHERE S.ASSIGNMENT_STATUS_TYPE_ID = TYP.ASSIGNMENT_STATUS_TYPE_ID
AND S.ASSIGNMENT_STATUS_TYPE_ID = AMD.ASSIGNMENT_STATUS_TYPE_ID(+)
AND S.BUSINESS_GROUP_ID + 0 = AMD.BUSINESS_GROUP_ID(+) + 0
AND TYP.PRIMARY_FLAG = 'S'
AND S.REASON = EMP.LOOKUP_CODE(+)
AND EMP.LOOKUP_TYPE(+) = 'EMP_SEC_ASSIGN_REASON'
AND S.REASON = APL.LOOKUP_CODE(+)
AND APL.LOOKUP_TYPE(+) = 'APL_SEC_ASSIGN_REASON'
AND S.REASON = CWK.LOOKUP_CODE(+)
AND CWK.LOOKUP_TYPE(+) = 'CWK_SEC_ASSIGN_REASON'
AND TYP.ASSIGNMENT_STATUS_TYPE_ID = TYPTL.ASSIGNMENT_STATUS_TYPE_ID
AND TYPTL.LANGUAGE = USERENV('LANG')
AND AMD.ASS_STATUS_TYPE_AMEND_ID = AMDTL.ASS_STATUS_TYPE_AMEND_ID (+)
AND DECODE (AMDTL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, AMDTL.LANGUAGE) = DECODE (AMDTL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, USERENV('LANG'))