1. Tables and Views for SCM
  2. CJM_XLA_DOO_SALESREP_V

CJM_XLA_DOO_SALESREP_V

Details

  • Schema: FUSION

  • Object owner: CJM

  • Object type: VIEW

Columns

Name

SALESREP_NUMBER

SALESREP_REV_CCID

FULFILL_LINE_ID

SALESPERSON_ID

Query

SQL_Statement

SELECT jrs.salesrep_number salesrep_number,

ar.rev_ccid salesrep_rev_ccid,

ofl.fulfill_line_id fulfill_line_id,

NVL(ofl.salesperson_id,ofh.salesperson_id) salesperson_id

FROM doo_fulfill_lines_all ofl,

doo_headers_all ofh,

jtf_rs_salesreps jrs,

ar_ref_accounts_all ar

WHERE ofl.header_id = ofh.header_id

AND jrs.resource_id = NVL(ofl.salesperson_id,ofh.salesperson_id)

AND ar.source_ref_account_id (+) = jrs.resource_salesrep_id

AND NVL(ar.source_ref_table,'RA_SALESREPS') = 'RA_SALESREPS'

AND ar.bu_id (+) = ofl.org_id