VIEW: APPS.OKX_CUST_ACCT_RELATE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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