View: OKX_BUYERS_V

Product:	OKX - Contracts Integration
Description:	Buyers
Implementation/DBA Data:	APPS.OKX_BUYERS_V

View Text

SELECT A.AGENT_ID ID1
, '#' ID2
, PERV.FULL_NAME NAME
, PERV.EMAIL_ADDRESS || ' ' || PERV.WORK_TELEPHONE DESCRIPTION
, A.CATEGORY_ID CATEGORY_ID
, PERV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, A.START_DATE_ACTIVE START_DATE_ACTIVE
, A.END_DATE_ACTIVE END_DATE_ACTIVE
, PERV.WORK_TELEPHONE WORK_TELEPHONE
, PERV.EMAIL_ADDRESS EMAIL_ADDRESS
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(A.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(A.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL SMALL_BUSINESS_FLAG
, NULL WOMEN_OWNED_FLAG
, NULL MINORITY_GROUP_LOOKUP
, NULL PARTY_ID
, '#' PARTY_ID2
FROM PO_AGENTS A
, OKX_PER_ALL_PEOPLE_V PERV
WHERE PERV.PERSON_ID = A.AGENT_ID

Columns