VIEW: APPS.AR_CM_SALESREP_S_V

Source

View Text - Preformatted

SELECT 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.event_id event_id ,he.line_number line_number ,he.ledger_id ledger_id ,he.language language FROM jtf_rs_salesreps shdrt ,ar_xla_lines_extract he WHERE shdrt.salesrep_id = he.salesrep_id AND shdrt.org_id = he.org_id AND he.level_flag = 'H' AND he.event_class_code = 'CREDIT_MEMO'

View Text - HTML Formatted

SELECT 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.EVENT_ID EVENT_ID
, HE.LINE_NUMBER LINE_NUMBER
, HE.LEDGER_ID LEDGER_ID
, HE.LANGUAGE LANGUAGE
FROM JTF_RS_SALESREPS SHDRT
, AR_XLA_LINES_EXTRACT HE
WHERE SHDRT.SALESREP_ID = HE.SALESREP_ID
AND SHDRT.ORG_ID = HE.ORG_ID
AND HE.LEVEL_FLAG = 'H'
AND HE.EVENT_CLASS_CODE = 'CREDIT_MEMO'