View: OKX_CUST_ACCT_RELATE_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	APPS.OKX_CUST_ACCT_RELATE_V

View Text

SELECT REL.RELATED_CUST_ACCOUNT_ID ID1
, '#'ID2
, CA.ACCOUNT_NAME NAME
, CA.ACCOUNT_NUMBER DESCRIPTION
, REL.STATUS STATUS
, TO_DATE('1950-01-01 00:00:00'
, 'YYYY-MM-DD HH24:MI:SS') START_DATE_ACTIVE
, TO_DATE(NULL) END_DATE_ACTIVE
, REL.CUST_ACCOUNT_ID CUSTOMER_ID
, REL.RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, REL.CUSTOMER_RECIPROCAL_FLAG CUSTOMER_RECIPROCAL_FLAG
, REL.ORG_ID ORG_ID
, REL.BILL_TO_FLAG BILL_TO_FLAG
, REL.SHIP_TO_FLAG SHIP_TO_FLAG
, CA.PARTY_ID PARTY_ID
FROM HZ_CUST_ACCT_RELATE_ALL REL
, HZ_CUST_ACCOUNTS CA
WHERE CA.CUST_ACCOUNT_ID = REL.CUST_ACCOUNT_ID

Columns