VRM_SALESREPS_V

Details

• Schema: FUSION

• Object owner: VRM

• Object type: VIEW

Columns

Name
SALESREP_ID SET_ID SALESREP_NAME SALESREP_FIRST_NAME SALESREP_MIDDLE_NAME SALESREP_LAST_NAME SALESREP_NUMBER CATEGORY

Query

SQL_Statement

SELECT JRS.RESOURCE_SALESREP_ID SALESREP_ID, JRS.SET_ID SET_ID, HZP.PARTY_NAME SALESREP_NAME , HZP.PERSON_FIRST_NAME SALESREP_FIRST_NAME, HZP.PERSON_MIDDLE_NAME SALESREP_MIDDLE_NAME, HZP.PERSON_LAST_NAME SALESREP_LAST_NAME, JRS.SALESREP_NUMBER SALESREP_NUMBER, NULL CATEGORY FROM JTF_RS_SALESREPS JRS, HZ_PARTIES HZP WHERE JRS.RESOURCE_ID = HZP.PARTY_ID UNION ALL SELECT nvl2(lk.lookup_code,-1,-1) SALESREP_ID , 0 SET_ID, lk.meaning SALESREP_NAME, lk.meaning SALESREP_FIRST_NAME, lk.meaning SALESREP_MIDDLE_NAME, lk.meaning SALESREP_LAST_NAME, '-3' SALESREP_NUMBER, NULL CATEGORY FROM ar_lookups lk WHERE lk.lookup_type = 'AR_SALES_CREDIT' AND lk.lookup_code = 'NO_SALES_CREDIT'