View: OKX_SALESREPS_V

Product:	OKX - Contracts Integration
Description:	Information about sales reps
Implementation/DBA Data:	APPS.OKX_SALESREPS_V

View Text

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
, S.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')

Columns