VIEW: APPS.JAI_OM_CUST_ADDRESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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