Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.RA_CUST_TRX_LINE_SALESREP_RA_V |
SELECT SCREDITS.ROWID
, SCREDITS.CUST_TRX_LINE_SALESREP_ID
, SCREDITS.LAST_UPDATE_DATE
, SCREDITS.LAST_UPDATED_BY
, SCREDITS.CREATION_DATE
, SCREDITS.CREATED_BY
, SCREDITS.LAST_UPDATE_LOGIN
, SCREDITS.CUSTOMER_TRX_ID
, ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER(SCREDITS.SALESREP_ID
, 'NAME'
, SCREDITS.ORG_ID)
, ARPT_SQL_FUNC_UTIL.GET_SALESREP_NAME_NUMBER(SCREDITS.SALESREP_ID
, 'NUMBER'
, SCREDITS.ORG_ID)
, SCREDITS.SALESREP_ID
, SCREDITS.CUSTOMER_TRX_LINE_ID
, SCREDITS.REVENUE_PERCENT_SPLIT
, SCREDITS.REVENUE_AMOUNT_SPLIT
, SCREDITS.NON_REVENUE_PERCENT_SPLIT
, SCREDITS.NON_REVENUE_AMOUNT_SPLIT
, SCREDITS.REQUEST_ID
, SCREDITS.PROGRAM_APPLICATION_ID
, SCREDITS.PROGRAM_ID
, SCREDITS.PROGRAM_UPDATE_DATE
, SCREDITS.ORIGINAL_LINE_SALESREP_ID
, SCREDITS.PREV_CUST_TRX_LINE_SALESREP_ID
, SCREDITS.ATTRIBUTE_CATEGORY
, SCREDITS.ATTRIBUTE1
, SCREDITS.ATTRIBUTE2
, SCREDITS.ATTRIBUTE3
, SCREDITS.ATTRIBUTE4
, SCREDITS.ATTRIBUTE5
, SCREDITS.ATTRIBUTE6
, SCREDITS.ATTRIBUTE7
, SCREDITS.ATTRIBUTE8
, SCREDITS.ATTRIBUTE9
, SCREDITS.ATTRIBUTE10
, SCREDITS.ATTRIBUTE11
, SCREDITS.ATTRIBUTE12
, SCREDITS.ATTRIBUTE13
, SCREDITS.ATTRIBUTE14
, SCREDITS.ATTRIBUTE15
, SCREDITS.REVENUE_ADJUSTMENT_ID
, REV_ADJ.REVENUE_ADJUSTMENT_NUMBER
, SCREDITS.REVENUE_SALESGROUP_ID
, REV_GROUP.GROUP_NAME
, SCREDITS.NON_REVENUE_SALESGROUP_ID
, NON_REV_GROUP.GROUP_NAME
FROM AR_REVENUE_ADJUSTMENTS REV_ADJ
, RA_CUST_TRX_LINE_SALESREPS SCREDITS
, JTF_RS_GROUPS_TL REV_GROUP
, JTF_RS_GROUPS_TL NON_REV_GROUP
WHERE SCREDITS.REVENUE_ADJUSTMENT_ID = REV_ADJ.REVENUE_ADJUSTMENT_ID(+)
AND SCREDITS.REVENUE_SALESGROUP_ID = REV_GROUP.GROUP_ID (+)
AND SCREDITS.NON_REVENUE_SALESGROUP_ID = NON_REV_GROUP.GROUP_ID (+)
AND REV_GROUP.LANGUAGE (+) = USERENV('LANG')
AND NON_REV_GROUP.LANGUAGE (+) = USERENV('LANG')