VIEW: APPS.OKX_SALESREPS_V

Source

View Text - Preformatted

SELECT S.SALESREP_ID ID1, '#' ID2, RES.RESOURCE_ID RESOURCE_ID, S.ORG_ID ORG_ID, S.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, S.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID, S.PERSON_ID PERSON_ID, RES.RESOURCE_NAME NAME, NULL DESCRIPTION, S.STATUS B_STATUS, S.STATUS STATUS, S.START_DATE_ACTIVE START_DATE_ACTIVE, S.END_DATE_ACTIVE END_DATE_ACTIVE, S.EMAIL_ADDRESS EMAIL_ADDRESS FROM JTF_RS_SALESREPS_MO_V S,JTF_RS_RESOURCE_EXTNS_VL RES WHERE S.RESOURCE_ID = RES.RESOURCE_ID and RES.CATEGORY in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')

View Text - HTML Formatted

SELECT S.SALESREP_ID ID1
, '#' ID2
, RES.RESOURCE_ID RESOURCE_ID
, S.ORG_ID ORG_ID
, S.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, S.SALES_CREDIT_TYPE_ID SALES_CREDIT_TYPE_ID
, S.PERSON_ID PERSON_ID
, RES.RESOURCE_NAME NAME
, NULL DESCRIPTION
, S.STATUS B_STATUS
, S.STATUS STATUS
, S.START_DATE_ACTIVE START_DATE_ACTIVE
, S.END_DATE_ACTIVE END_DATE_ACTIVE
, S.EMAIL_ADDRESS EMAIL_ADDRESS
FROM JTF_RS_SALESREPS_MO_V S
, JTF_RS_RESOURCE_EXTNS_VL RES
WHERE S.RESOURCE_ID = RES.RESOURCE_ID
AND RES.CATEGORY IN ('EMPLOYEE'
, 'OTHER'
, 'PARTY'
, 'PARTNER'
, 'SUPPLIER_CONTACT')