View: RA_SALESREPS

Product:	AR - Receivables
Description:	Backward compatible single-org view for ra_salesreps_all
Implementation/DBA Data:	APPS.RA_SALESREPS

View Text

SELECT JRS.SALESREP_ID
, JRS.LAST_UPDATE_DATE
, JRS.LAST_UPDATED_BY
, JRS.CREATION_DATE
, JRS.CREATED_BY
, JRS.LAST_UPDATE_LOGIN
, JRS.SALES_CREDIT_TYPE_ID
, RES.RESOURCE_NAME
, JRS.SALESREP_NUMBER
, JRS.STATUS
, JRS.START_DATE_ACTIVE
, JRS.END_DATE_ACTIVE
, JRS.GL_ID_REV
, JRS.GL_ID_FREIGHT
, JRS.GL_ID_REC
, JRS.SET_OF_BOOKS_ID
, JRS.ATTRIBUTE_CATEGORY
, JRS.ATTRIBUTE1
, JRS.ATTRIBUTE2
, JRS.ATTRIBUTE3
, JRS.ATTRIBUTE4
, JRS.ATTRIBUTE5
, JRS.ATTRIBUTE6
, JRS.ATTRIBUTE7
, JRS.ATTRIBUTE8
, JRS.ATTRIBUTE9
, JRS.ATTRIBUTE10
, JRS.ATTRIBUTE11
, JRS.ATTRIBUTE12
, JRS.ATTRIBUTE13
, JRS.ATTRIBUTE14
, JRS.ATTRIBUTE15
, JRS.ORG_ID
, RES.SOURCE_EMAIL EMAIL_ADDRESS
, RES.ASSIGNED_TO_GROUP_ID ASSIGNED_TO_USER_ID
, RES.COST_CENTER
, RES.CHARGE_TO_COST_CENTER
, RES.COMPENSATION_CURRENCY_CODE
, JRS.WH_UPDATE_DATE
, RES.SOURCE_ID
, RES.CATEGORY TYPE
, JRS.SALES_TAX_GEOCODE
, JRS.SALES_TAX_INSIDE_CITY_LIMITS
, RES.COMMISSIONABLE_FLAG
FROM JTF_RS_SALESREPS_MO_V JRS
, JTF_RS_RESOURCE_EXTNS_VL RES
WHERE JRS.RESOURCE_ID = RES.RESOURCE_ID
AND RES.CATEGORY IN ('EMPLOYEE'
, 'OTHER'
, 'PARTY'
, 'PARTNER'
, 'SUPPLIER_CONTACT')

Columns