View: AS_OTH_SALESREPS_V

View Text

SELECT ASF.ROWID
, RA.SALESREP_ID
, RA.LAST_UPDATE_DATE
, RA.LAST_UPDATED_BY
, RA.CREATION_DATE
, RA.CREATED_BY
, RA.LAST_UPDATE_LOGIN
, RA.SALES_CREDIT_TYPE_ID
, RA.NAME
, RA.STATUS
, RA.START_DATE_ACTIVE
, RA.END_DATE_ACTIVE
, RA.GL_ID_REV
, RA.GL_ID_FREIGHT
, RA.GL_ID_REC
, RA.SET_OF_BOOKS_ID
, ASF.ATTRIBUTE_CATEGORY
, ASF.ATTRIBUTE1
, ASF.ATTRIBUTE2
, ASF.ATTRIBUTE3
, ASF.ATTRIBUTE4
, ASF.ATTRIBUTE5
, ASF.ATTRIBUTE6
, ASF.ATTRIBUTE7
, ASF.ATTRIBUTE8
, ASF.ATTRIBUTE9
, ASF.ATTRIBUTE10
, RA.SALESREP_NUMBER
, ASF.ATTRIBUTE11
, ASF.ATTRIBUTE12
, ASF.ATTRIBUTE13
, ASF.ATTRIBUTE14
, ASF.ATTRIBUTE15
, RA.ORG_ID
, RA.EMAIL_ADDRESS
, RA.ASSIGNED_TO_USER_ID
, RA.COST_CENTER
, RA.CHARGE_TO_COST_CENTER
, RA.START_PROCESSING_PERIOD_ID
, RA.END_PROCESSING_PERIOD_ID
, RA.COMPENSATION_CURRENCY_CODE
, RA.WH_UPDATE_DATE
, RA.PERSON_ID
, ASF.TYPE
, RA.SALESFORCE_ID
, RA.COMMISSIONABLE_FLAG
, ASF.STATUS_CODE
, ST.NAME
, PS.PERIOD_NAME
, PE.PERIOD_NAME
, U.USER_NAME
, ASL.MEANING
, RA.SALES_TAX_GEOCODE
, RA.SALES_TAX_INSIDE_CITY_LIMITS
FROM AS_SALESFORCE ASF
, CN_PERIOD_STATUSES PS
, FND_USER U
, RA_SALESREPS_ALL RA
, SO_SALES_CREDIT_TYPES_115 ST
, CN_PERIOD_STATUSES PE
, AS_LOOKUPS ASL
WHERE NVL(RA.ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND RA.SALESFORCE_ID = ASF.SALESFORCE_ID
AND ASF.TYPE = ASL.LOOKUP_CODE (+)
AND ASF.TYPE = 'OTHERS'
AND ASL.LOOKUP_TYPE (+) = 'SALESFORCE_TYPE'
AND RA.SALES_CREDIT_TYPE_ID = ST.SALES_CREDIT_TYPE_ID (+)
AND RA.START_PROCESSING_PERIOD_ID = PS.PERIOD_ID (+)
AND RA.END_PROCESSING_PERIOD_ID = PE.PERIOD_ID (+)
AND RA.ASSIGNED_TO_USER_ID = U.USER_ID (+)

Columns