VIEW: APPS.AR_SALESREP_L_V

Source

View Text - Preformatted

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ slnf.gl_id_freight rep_l_freight_ccid ,slnf.gl_id_rec rep_l_rec_ccid ,slnf.gl_id_rev rep_l_rev_ccid ,slnf.name rep_l_name ,slnf.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 ,ar_xla_lines_extract l WHERE slnf.salesrep_id = l.cust_trx_line_salesrep_id and slnf.org_id = l.org_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 GROUP BY slnf.gl_id_freight ,slnf.gl_id_rec ,slnf.gl_id_rev ,slnf.name ,slnf.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

View Text - HTML Formatted

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ SLNF.GL_ID_FREIGHT REP_L_FREIGHT_CCID
, SLNF.GL_ID_REC REP_L_REC_CCID
, SLNF.GL_ID_REV REP_L_REV_CCID
, SLNF.NAME REP_L_NAME
, SLNF.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
, AR_XLA_LINES_EXTRACT L
WHERE SLNF.SALESREP_ID = L.CUST_TRX_LINE_SALESREP_ID
AND SLNF.ORG_ID = L.ORG_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 GROUP BY SLNF.GL_ID_FREIGHT
, SLNF.GL_ID_REC
, SLNF.GL_ID_REV
, SLNF.NAME
, SLNF.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