View: PO_AGENTS_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_AGENTS_V

View Text

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')

Columns