[Home] [Help]
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 = CTLSAF.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
Name |
REP_L_FREIGHT_CCID |
REP_L_REC_CCID |
REP_L_REV_CCID |
REP_L_NAME |
REP_L_SALESREP_ID |
REP_L_SALESREP_NUMBER |
REP_L_SALES_TAX_GEOCODE |
REP_L_SALES_TAX_INSIDE_CITY_LM |
EVENT_ID |
LINE_NUMBER |
LANGUAGE |
LEDGER_ID |