Product: | AR - Receivables |
---|---|
Description: | credit memo salesrep shared extract |
Implementation/DBA Data: | APPS.AR_CM_SALESREP_S_V |
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'