AR_SALESREP_L_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
REP_L_FREIGHT_CCID REP_L_REC_CCID REP_L_REV_CCID REP_L_NAME REP_L_SALESREP_ID REP_L_SALESREP_NUMBER REP_L_SALES_TAX_GEOCODE REP_L_SALES_TAX_INSIDE_CITY_LM EVENT_ID LINE_NUMBER LANGUAGE LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ ref.freight_ccid rep_l_freight_ccid , ref.rec_ccid rep_l_rec_ccid , ref.rev_ccid rep_l_rev_ccid , decode(slnf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME) rep_l_name , slnf.resource_salesrep_id rep_l_salesrep_id , slnf.salesrep_number rep_l_salesrep_number , slnf.sales_tax_geocode rep_l_sales_tax_geocode , slnf.sales_tax_inside_city_limits rep_l_sales_tax_inside_city_lm , l.event_id event_id , l.line_number line_number , l.language language , l.ledger_id ledger_id FROM ra_cust_trx_line_salesreps_all ctlsaf , jtf_rs_salesreps slnf , HZ_PARTIES hzp, ar_ref_accounts_All ref, ar_xla_lines_extract l WHERE slnf.resource_salesrep_id = ctlsaf.resource_salesrep_id AND ctlsaf.cust_trx_line_salesrep_id = l.cust_trx_line_salesrep_id AND l.level_flag = 'L' AND ctlsaf.org_id = l.org_id AND ref.source_ref_table(+) = 'RA_SALESREPS' AND ref.source_ref_account_id(+) = ctlsaf.resource_salesrep_id AND ref.bu_id(+) = ctlsaf.org_id AND slnf.RESOURCE_ID = HZP.PARTY_ID (+) GROUP BY ref.freight_ccid , ref.rec_ccid , ref.rev_ccid , decode(slnf.RESOURCE_ID, -1, 'No Sales Credit', HZP.PARTY_NAME), slnf.resource_salesrep_id , slnf.salesrep_number , slnf.sales_tax_geocode , slnf.sales_tax_inside_city_limits , l.event_id , l.line_number , l.language , l.ledger_id