FND Design Data [Home] [Help]

View: AR_RECEIPT_TRX_TYPE_VIEW

Product: AR - Receivables
Description: A union of AR_RECEIPT_METHODS and RA_CUST_TRX_TYPES
Implementation/DBA Data: ViewAPPS.AR_RECEIPT_TRX_TYPE_VIEW
View Text

SELECT NAME
, NAME
, NULL
, TO_NUMBER(NULL)
, RECEIPT_METHOD_ID
FROM AR_RECEIPT_METHODS UNION SELECT NAME
, DESCRIPTION
, TYPE
, CUST_TRX_TYPE_ID
, TO_NUMBER(NULL)
FROM RA_CUST_TRX_TYPES

Columns

Name
NAME
DESCRIPTION
TYPE
CUST_TRX_TYPE_ID
RECEIPT_METHOD_ID