FND Design Data [Home] [Help]

View: AR_TA_INT_CUST_REF_NUM_V

Product: AR - Receivables
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT DISTINCT RH1.CUSTOMER_REF_NUMBER CUSTOMER_REFERENCE_NUMBER
FROM AR_TA_REMIT_HIST RH1
, AR_TA_REMIT_HIST RH2
WHERE RH1.RECORD_TYPE=6
AND RH2.RECORD_TYPE=7
AND RH2.PARENT_HISTORY_LINE_ID=RH1.HISTORY_LINE_ID

Columns

Name
CUSTOMER_REFERENCE_NUMBER