VIEW: APPS.ARFV_NON_REVENUE_CREDITS

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ RCT.CUST_TRX_LINE_SALESREP_ID , /* REGULAR ATTRIBUTES */ RCT.NON_REVENUE_AMOUNT_SPLIT , RCT.NON_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

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ RCT.CUST_TRX_LINE_SALESREP_ID
, /* REGULAR ATTRIBUTES */ RCT.NON_REVENUE_AMOUNT_SPLIT
, RCT.NON_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