VIEW: APPS.RA_CUST_TRX_LINE_SALESREPS_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 , 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')

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