VIEW: APPS.PO_AGENTS_V

Source

View Text - Preformatted

SELECT /*+ ORDERED USE_NL ( PA, PAPF, HL) */ PA.ROWID , PA.AGENT_ID , PAPF.FULL_NAME , PA.LAST_UPDATE_DATE , PA.LAST_UPDATED_BY , PA.LAST_UPDATE_LOGIN , PA.CREATION_DATE , PA.CREATED_BY , PA.LOCATION_ID , HL.LOCATION_CODE , PA.CATEGORY_ID , PA.AUTHORIZATION_LIMIT , PA.START_DATE_ACTIVE , PA.END_DATE_ACTIVE , PA.ATTRIBUTE_CATEGORY , PA.ATTRIBUTE1 , PA.ATTRIBUTE2 , PA.ATTRIBUTE3 , PA.ATTRIBUTE4 , PA.ATTRIBUTE5 , PA.ATTRIBUTE6 , PA.ATTRIBUTE7 , PA.ATTRIBUTE8 , PA.ATTRIBUTE9 , PA.ATTRIBUTE10 , PA.ATTRIBUTE11 , PA.ATTRIBUTE12 , PA.ATTRIBUTE13 , PA.ATTRIBUTE14 , PA.ATTRIBUTE15 , PA.REQUEST_ID , PA.PROGRAM_APPLICATION_ID , PA.PROGRAM_ID , PA.PROGRAM_UPDATE_DATE FROM PO_AGENTS PA, PER_ALL_PEOPLE_F PAPF, HR_LOCATIONS_ALL_TL HL WHERE PA.AGENT_ID = PAPF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND DECODE(HR_GENERAL.GET_XBG_PROFILE,'Y',PAPF.BUSINESS_GROUP_ID, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID AND PA.LOCATION_ID = HL.LOCATION_ID(+) AND HL.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT /*+ ORDERED USE_NL ( PA
, PAPF
, HL) */ PA.ROWID
, PA.AGENT_ID
, PAPF.FULL_NAME
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, PA.LAST_UPDATE_LOGIN
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LOCATION_ID
, HL.LOCATION_CODE
, PA.CATEGORY_ID
, PA.AUTHORIZATION_LIMIT
, PA.START_DATE_ACTIVE
, PA.END_DATE_ACTIVE
, PA.ATTRIBUTE_CATEGORY
, PA.ATTRIBUTE1
, PA.ATTRIBUTE2
, PA.ATTRIBUTE3
, PA.ATTRIBUTE4
, PA.ATTRIBUTE5
, PA.ATTRIBUTE6
, PA.ATTRIBUTE7
, PA.ATTRIBUTE8
, PA.ATTRIBUTE9
, PA.ATTRIBUTE10
, PA.ATTRIBUTE11
, PA.ATTRIBUTE12
, PA.ATTRIBUTE13
, PA.ATTRIBUTE14
, PA.ATTRIBUTE15
, PA.REQUEST_ID
, PA.PROGRAM_APPLICATION_ID
, PA.PROGRAM_ID
, PA.PROGRAM_UPDATE_DATE
FROM PO_AGENTS PA
, PER_ALL_PEOPLE_F PAPF
, HR_LOCATIONS_ALL_TL HL
WHERE PA.AGENT_ID = PAPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAPF.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAPF.BUSINESS_GROUP_ID
AND PA.LOCATION_ID = HL.LOCATION_ID(+)
AND HL.LANGUAGE (+) = USERENV('LANG')