VIEW: APPS.RA_SALESREPS

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')