VIEW: APPS.AR_CM_SALESREP_H_V

Source

View Text - Preformatted

SELECT /*+INDEX (he ar_xla_lines_extract_n1) */ shdrt.gl_id_freight cm_rep_h_freight_ccid ,shdrt.gl_id_rec cm_rep_h_rec_ccid ,shdrt.gl_id_rev cm_rep_h_rev_ccid ,shdrt.name cm_rep_h_name ,shdrt.salesrep_id cm_rep_h_salesrep_id ,shdrt.salesrep_number cm_rep_h_salesrep_number ,shdrt.sales_tax_geocode cm_rep_h_sales_tax_geocode ,shdrt.sales_tax_inside_city_limits cm_rep_h_sales_tax_ins_city_lm ,he.ledger_id ledger_id ,he.event_id event_id FROM jtf_rs_salesreps shdrt ,ar_xla_lines_extract he WHERE he.level_flag = 'H' and shdrt.salesrep_id = he.salesrep_id and shdrt.org_id = he.org_id

View Text - HTML Formatted

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1) */ SHDRT.GL_ID_FREIGHT CM_REP_H_FREIGHT_CCID
, SHDRT.GL_ID_REC CM_REP_H_REC_CCID
, SHDRT.GL_ID_REV CM_REP_H_REV_CCID
, SHDRT.NAME CM_REP_H_NAME
, SHDRT.SALESREP_ID CM_REP_H_SALESREP_ID
, SHDRT.SALESREP_NUMBER CM_REP_H_SALESREP_NUMBER
, SHDRT.SALES_TAX_GEOCODE CM_REP_H_SALES_TAX_GEOCODE
, SHDRT.SALES_TAX_INSIDE_CITY_LIMITS CM_REP_H_SALES_TAX_INS_CITY_LM
, HE.LEDGER_ID LEDGER_ID
, HE.EVENT_ID EVENT_ID
FROM JTF_RS_SALESREPS SHDRT
, AR_XLA_LINES_EXTRACT HE
WHERE HE.LEVEL_FLAG = 'H'
AND SHDRT.SALESREP_ID = HE.SALESREP_ID
AND SHDRT.ORG_ID = HE.ORG_ID