VIEW: APPS.POFV_BUYERS

Source

View Text - Preformatted

SELECT br.AGENT_ID, pp.EMPLOYEE_NUMBER, pp.FULL_NAME, br.AUTHORIZATION_LIMIT, br.START_DATE_ACTIVE, br.END_DATE_ACTIVE, '_DF:PO:PO_AGENTS:br', br.CATEGORY_ID, '_KF:INV:MCAT:ct', br.LOCATION_ID, lo.LOCATION_CODE, br.CREATION_DATE, br.CREATED_BY, br.LAST_UPDATE_DATE, br.LAST_UPDATED_BY FROM PO_AGENTS br, PER_PEOPLE_F pp, HR_LOCATIONS lo, MTL_CATEGORIES ct WHERE br.AGENT_ID = pp.PERSON_ID AND pp.EFFECTIVE_START_DATE <= TRUNC(SYSDATE) AND pp.EFFECTIVE_END_DATE >= TRUNC(SYSDATE) AND br.LOCATION_ID = lo.LOCATION_ID(+) AND br.CATEGORY_ID = ct.CATEGORY_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT BR.AGENT_ID
, PP.EMPLOYEE_NUMBER
, PP.FULL_NAME
, BR.AUTHORIZATION_LIMIT
, BR.START_DATE_ACTIVE
, BR.END_DATE_ACTIVE
, '_DF:PO:PO_AGENTS:BR'
, BR.CATEGORY_ID
, '_KF:INV:MCAT:CT'
, BR.LOCATION_ID
, LO.LOCATION_CODE
, BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
FROM PO_AGENTS BR
, PER_PEOPLE_F PP
, HR_LOCATIONS LO
, MTL_CATEGORIES CT
WHERE BR.AGENT_ID = PP.PERSON_ID
AND PP.EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND PP.EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
AND BR.LOCATION_ID = LO.LOCATION_ID(+)
AND BR.CATEGORY_ID = CT.CATEGORY_ID(+) WITH READ ONLY