VIEW: APPS.RA_CUST_TRX_LINE_SALESREP_RA_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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