[Home] [Help]
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
Name |
ID1 |
ID2 |
RESOURCE_ID |
ORG_ID |
SET_OF_BOOKS_ID |
SALES_CREDIT_TYPE_ID |
PERSON_ID |
NAME |
DESCRIPTION |
B_STATUS |
STATUS |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
EMAIL_ADDRESS |