View: AR_SALESREP_L_V

Product:	AR - Receivables
Description:	salesrep line extract
Implementation/DBA Data:	APPS.AR_SALESREP_L_V

View Text

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ SLNF.GL_ID_FREIGHT REP_L_FREIGHT_CCID
, SLNF.GL_ID_REC REP_L_REC_CCID
, SLNF.GL_ID_REV REP_L_REV_CCID
, SLNF.NAME REP_L_NAME
, SLNF.SALESREP_ID REP_L_SALESREP_ID
, SLNF.SALESREP_NUMBER REP_L_SALESREP_NUMBER
, SLNF.SALES_TAX_GEOCODE REP_L_SALES_TAX_GEOCODE
, SLNF.SALES_TAX_INSIDE_CITY_LIMITS REP_L_SALES_TAX_INSIDE_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 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

Columns