VIEW: APPS.XNB_RELATED_ACCOUNTS_V

Source

View Text - Preformatted

SELECT B.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, B.RELATED_CUST_ACCOUNT_ID RELATED_CUST_ACCOUNT_ID, A.ACCOUNT_NUMBER RELATED_ACCOUNT_NUMBER, A.ACCOUNT_NAME RELATED_ACCOUNT_NAME, B.RELATIONSHIP_TYPE RELATIONSHIP_TYPE, B.ORG_ID ORG_ID, B.SHIP_TO_FLAG SHIP_TO_FLAG, B.BILL_TO_FLAG BILL_TO_FLAG FROM HZ_CUST_ACCT_RELATE_ALL B, HZ_CUST_ACCOUNTS A WHERE A.CUST_ACCOUNT_ID = B.RELATED_CUST_ACCOUNT_ID AND B.STATUS = 'A'

View Text - HTML Formatted

SELECT B.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, B.RELATED_CUST_ACCOUNT_ID RELATED_CUST_ACCOUNT_ID
, A.ACCOUNT_NUMBER RELATED_ACCOUNT_NUMBER
, A.ACCOUNT_NAME RELATED_ACCOUNT_NAME
, B.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, B.ORG_ID ORG_ID
, B.SHIP_TO_FLAG SHIP_TO_FLAG
, B.BILL_TO_FLAG BILL_TO_FLAG
FROM HZ_CUST_ACCT_RELATE_ALL B
, HZ_CUST_ACCOUNTS A
WHERE A.CUST_ACCOUNT_ID = B.RELATED_CUST_ACCOUNT_ID
AND B.STATUS = 'A'