VIEW: APPS.AR_CM_SALESREP_L_V

Source

View Text - Preformatted

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ slnf.gl_id_freight cm_rep_l_freight_ccid ,slnf.gl_id_rec cm_rep_l_rec_ccid ,slnf.gl_id_rev cm_rep_l_rev_ccid ,slnf.name cm_rep_l_name ,slnf.salesrep_id cm_rep_l_salesrep_id ,slnf.salesrep_number cm_rep_l_salesrep_number ,slnf.sales_tax_geocode cm_rep_l_sales_tax_geocode ,slnf.sales_tax_inside_city_limits cm_rep_l_sales_tax_ins_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 AND l.event_type_code IN ('CM_CREATE','CM_UPDATE') 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 CM_REP_L_FREIGHT_CCID
, SLNF.GL_ID_REC CM_REP_L_REC_CCID
, SLNF.GL_ID_REV CM_REP_L_REV_CCID
, SLNF.NAME CM_REP_L_NAME
, SLNF.SALESREP_ID CM_REP_L_SALESREP_ID
, SLNF.SALESREP_NUMBER CM_REP_L_SALESREP_NUMBER
, SLNF.SALES_TAX_GEOCODE CM_REP_L_SALES_TAX_GEOCODE
, SLNF.SALES_TAX_INSIDE_CITY_LIMITS CM_REP_L_SALES_TAX_INS_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
AND L.EVENT_TYPE_CODE IN ('CM_CREATE'
, 'CM_UPDATE') 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