View: JAI_OM_CUST_ADDRESS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_OM_CUST_ADDRESS_V

View Text

SELECT RELATED_CUST_ACCOUNT_ID RELATED_CUSTOMER_ID
, CUST_ACCOUNT_ID CUSTOMER_ID
, 1 CODE
FROM HZ_CUST_ACCT_RELATE_ALL
WHERE CUSTOMER_RECIPROCAL_FLAG = 'Y' UNION ALL SELECT CUST_ACCOUNT_ID CUSTOMER_ID
, RELATED_CUST_ACCOUNT_ID RELATED_CUSTOMER_ID
, 2 CODE
FROM HZ_CUST_ACCT_RELATE_ALL

Columns