VIEW: APPS.OKX_BUYERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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