SELECT CUST_ACCT.CUST_ACCOUNT_ID, PARTY.PARTY_NAME, CUST_ACCT.ACCOUNT_NUMBER, NVL(CUST_ACCT.STATUS, 'A'), PARTY.PARTY_ID, PARTY.PARTY_TYPE FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
SELECT CUST_ACCT.CUST_ACCOUNT_ID
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
, NVL(CUST_ACCT.STATUS
, 'A')
, PARTY.PARTY_ID
, PARTY.PARTY_TYPE
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
|
|
|