CST_XLA_COGS_SALES_CREDITS

Details

Name
PRIMARY_SALESREP_ID PRIMARY_SALESREP_REV_CCID FULFILL_LINE_ID PRIMARY_SALESREP_NUMBER

Name

PRIMARY_SALESREP_ID

PRIMARY_SALESREP_REV_CCID

FULFILL_LINE_ID

PRIMARY_SALESREP_NUMBER

SQL_Statement
SELECT jrs.resource_id primary_salesrep_id, ar.rev_ccid primary_salesrep_rev_ccid, ofl.fulfill_line_id fulfill_line_id, jrs.salesrep_number primary_salesrep_number 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 ar.source_ref_table (+) = 'RA_SALESREPS' AND ar.bu_id (+) = ofl.org_id AND jrs.SET_ID IN (0, FND_SetID_Utility.getSetID( 'HZ_SALES_PERSON', 'BU',ofl.org_id))

SQL_Statement

SELECT jrs.resource_id primary_salesrep_id,

ar.rev_ccid primary_salesrep_rev_ccid,

ofl.fulfill_line_id fulfill_line_id,

jrs.salesrep_number primary_salesrep_number

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 ar.source_ref_table (+) = 'RA_SALESREPS'

AND ar.bu_id (+) = ofl.org_id

AND jrs.SET_ID IN (0, FND_SetID_Utility.getSetID( 'HZ_SALES_PERSON', 'BU',ofl.org_id))