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