View: AR_CM_SALESREP_H_V

Product:	AR - Receivables
Description:	AR XLA Extract
Implementation/DBA Data:	APPS.AR_CM_SALESREP_H_V

View Text

SELECT /*+INDEX (HE AR_XLA_LINES_EXTRACT_N1) */ 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.LEDGER_ID LEDGER_ID
, HE.EVENT_ID EVENT_ID
FROM JTF_RS_SALESREPS SHDRT
, AR_XLA_LINES_EXTRACT HE
WHERE HE.LEVEL_FLAG = 'H'
AND SHDRT.SALESREP_ID = HE.SALESREP_ID
AND SHDRT.ORG_ID = HE.ORG_ID

Columns