View: ARFV_REVENUE_CREDITS

Product:	AR - Receivables
Description:	This shows revenue credit information for a transaction.
Implementation/DBA Data:	APPS.ARFV_REVENUE_CREDITS

View Text

SELECT /* UNIQUE ATTRIBUTES */ RCT.CUST_TRX_LINE_SALESREP_ID
, /* REGULAR ATTRIBUTES */ RCT.REVENUE_AMOUNT_SPLIT
, RCT.REVENUE_PERCENT_SPLIT
, '_DF:AR:RA_CUST_TRX_LINE_SALESREPS:RCT'
, /* RESOLVED FK RESOLUTIONS */ AOU.NAME
, CTL.SALES_ORDER
, RS.NAME
, RS.SALESREP_NUMBER
, CT.TRX_NUMBER
, CTL.LINE_NUMBER
, /* IDS */ RCT.CUSTOMER_TRX_ID
, RCT.CUSTOMER_TRX_LINE_ID
, RCT.SALESREP_ID
, RCT.ORG_ID
, /* WHO COLUMNS */ RCT.LAST_UPDATE_DATE
, RCT.LAST_UPDATED_BY
, RCT.CREATION_DATE
, RCT.CREATED_BY
FROM RA_CUST_TRX_LINE_SALESREPS RCT
, HR_ALL_ORGANIZATION_UNITS AOU
, RA_CUSTOMER_TRX_LINES CTL
, RA_SALESREPS RS
, RA_CUSTOMER_TRX CT
WHERE RCT.ORG_ID = AOU.ORGANIZATION_ID (+)
AND RCT.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND RCT.CUSTOMER_TRX_LINE_ID = CTL.CUSTOMER_TRX_LINE_ID (+)
AND RCT.SALESREP_ID = RS.SALESREP_ID
AND ((RCT.SALESREP_ID IS NULL) OR (RCT.SALESREP_ID IS NOT NULL
AND NVL(RCT.ORG_ID
, -12345) = NVL(RS.ORG_ID
, -12345)) ) WITH READ ONLY

Columns