View: RA_CUST_TRX_LINE_SALESREPS_V

Product:	AR - Receivables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.RA_CUST_TRX_LINE_SALESREPS_V

View Text

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
, SALESREP.NAME
, SALESREP.SALESREP_NUMBER
, SCREDITS.SALESREP_ID
, TRX_LINE.LINE_NUMBER
, SCREDITS.CUSTOMER_TRX_LINE_ID
, TRX_LINE.EXTENDED_AMOUNT
, ARP_BAL_UTIL.GET_LINE_CM(TRX_LINE.CUSTOMER_TRX_LINE_ID)
, ARP_BAL_UTIL.GET_LINE_BALANCE(TRX_LINE.CUSTOMER_TRX_LINE_ID
, TRX_LINE.EXTENDED_AMOUNT)
, SCREDITS.REVENUE_PERCENT_SPLIT
, SCREDITS.REVENUE_AMOUNT_SPLIT
, SCREDITS.NON_REVENUE_PERCENT_SPLIT
, SCREDITS.NON_REVENUE_AMOUNT_SPLIT
, PREV_SREP.SALESREP_ID
, PREV_SREP.NAME
, PREV_SREP.SALESREP_NUMBER
, PREV_SCREDIT.REVENUE_PERCENT_SPLIT
, PREV_SCREDIT.REVENUE_AMOUNT_SPLIT
, PREV_SCREDIT.NON_REVENUE_PERCENT_SPLIT
, PREV_SCREDIT.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_SALESGROUP_ID
, REV_GROUP.GROUP_NAME
, SCREDITS.NON_REVENUE_SALESGROUP_ID
, NON_REV_GROUP.GROUP_NAME
FROM RA_SALESREPS SALESREP
, RA_SALESREPS PREV_SREP
, RA_CUST_TRX_LINE_SALESREPS PREV_SCREDIT
, RA_CUSTOMER_TRX_LINES TRX_LINE
, RA_CUST_TRX_LINE_SALESREPS SCREDITS
, JTF_RS_GROUPS_TL REV_GROUP
, JTF_RS_GROUPS_TL NON_REV_GROUP
WHERE SCREDITS.SALESREP_ID = SALESREP.SALESREP_ID
AND SCREDITS.CUSTOMER_TRX_LINE_ID = TRX_LINE.CUSTOMER_TRX_LINE_ID (+)
AND SCREDITS.PREV_CUST_TRX_LINE_SALESREP_ID = PREV_SCREDIT.CUST_TRX_LINE_SALESREP_ID(+)
AND PREV_SCREDIT.SALESREP_ID = PREV_SREP.SALESREP_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')

Columns