AR_SALESREP_S

Details

Name
REP_H_FREIGHT_CCID REP_H_REC_CCID REP_H_REV_CCID REP_H_NAME REP_H_SALESREP_ID REP_H_SALESREP_NUMBER REP_H_SALES_TAX_GEOCODE REP_H_SALES_TAX_INSIDE_CITY_LM EVENT_ID LINE_NUMBER LEDGER_ID

Name

REP_H_FREIGHT_CCID

REP_H_REC_CCID

REP_H_REV_CCID

REP_H_NAME

REP_H_SALESREP_ID

REP_H_SALESREP_NUMBER

REP_H_SALES_TAX_GEOCODE

REP_H_SALES_TAX_INSIDE_CITY_LM

EVENT_ID

LINE_NUMBER

LEDGER_ID

SQL_Statement
SELECT /+INDEX(l ar_xla_lines_extract_n1)/ ref.freight_ccid rep_h_freight_ccid , ref.rec_ccid rep_h_rec_ccid , ref.rev_ccid rep_h_rev_ccid , decode(shdrf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME) rep_h_name , shdrf.resource_salesrep_id rep_h_salesrep_id , shdrf.salesrep_number rep_h_salesrep_number , shdrf.sales_tax_geocode rep_h_sales_tax_geocode , shdrf.sales_tax_inside_city_limits rep_h_sales_tax_inside_city_lm , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM jtf_rs_salesreps shdrf , HZ_PARTIES hzp, ar_ref_accounts_All ref, ar_xla_lines_extract l WHERE shdrf.resource_salesrep_id = l.resource_salesrep_id AND ref.source_ref_table(+) = 'RA_SALESREPS' AND ref.source_ref_account_id(+) = l.resource_salesrep_id AND ref.bu_id(+) = l.org_id AND shdrf.RESOURCE_ID = HZP.PARTY_ID (+) AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT','BILL') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))

SQL_Statement

SELECT

/*+INDEX(l ar_xla_lines_extract_n1)*/

ref.freight_ccid rep_h_freight_ccid ,

ref.rec_ccid rep_h_rec_ccid ,

ref.rev_ccid rep_h_rev_ccid ,

decode(shdrf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME) rep_h_name ,

shdrf.resource_salesrep_id rep_h_salesrep_id ,

shdrf.salesrep_number rep_h_salesrep_number ,

shdrf.sales_tax_geocode rep_h_sales_tax_geocode ,

shdrf.sales_tax_inside_city_limits rep_h_sales_tax_inside_city_lm ,

l.event_id event_id ,

l.line_number line_number ,

l.ledger_id ledger_id

FROM jtf_rs_salesreps shdrf ,

HZ_PARTIES hzp,

ar_ref_accounts_All ref,

ar_xla_lines_extract l

WHERE shdrf.resource_salesrep_id = l.resource_salesrep_id

AND ref.source_ref_table(+) = 'RA_SALESREPS'

AND ref.source_ref_account_id(+) = l.resource_salesrep_id

AND ref.bu_id(+) = l.org_id

AND shdrf.RESOURCE_ID = HZP.PARTY_ID (+)

AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT','BILL')

AND l.level_flag = 'H')

OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT')

AND l.level_flag = 'L'

AND l.from_to_flag = 'T'))