[Home] [Help]
SELECT A.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, B.ORG_ID ORG_ID, D.EXT_BANK_ACCOUNT_ID BANK_ACCOUNT_ID, F.BANK_OR_BRANCH_NUMBER BANK_NUMBER, D.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUMBER, D.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME, D.BRANCH_ID BANK_BRANCH_ID, D.CURRENCY_CODE CURRENCY_CODE, E.PARTY_NAME ACCOUNT_HOLDER_NAME, C.END_DATE INACTIVE_DATE FROM HZ_CUST_ACCOUNTS A, IBY_EXTERNAL_PAYERS_ALL B, IBY_PMT_INSTR_USES_ALL C, IBY_EXT_BANK_ACCOUNTS D, HZ_PARTIES E, HZ_ORGANIZATION_PROFILES F WHERE A.CUST_ACCOUNT_ID = B.CUST_ACCOUNT_ID AND B.EXT_PAYER_ID = C.EXT_PMT_PARTY_ID AND C.INSTRUMENT_TYPE = 'BANKACCOUNT' AND C.INSTRUMENT_ID = D.EXT_BANK_ACCOUNT_ID AND A.PARTY_ID = E.PARTY_ID AND D.bank_id = F.party_id AND (C.END_DATE IS NULL OR C.END_DATE > SYSDATE) AND (D.END_DATE IS NULL OR D.END_DATE > SYSDATE) GROUP BY A.CUST_ACCOUNT_ID, B.ORG_ID, D.EXT_BANK_ACCOUNT_ID, F.BANK_OR_BRANCH_NUMBER, D.BANK_ACCOUNT_NUM, D.BANK_ACCOUNT_NAME, D.BRANCH_ID, D.CURRENCY_CODE, E.PARTY_NAME, C.END_DATE
SELECT A.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, B.ORG_ID ORG_ID
, D.EXT_BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, F.BANK_OR_BRANCH_NUMBER BANK_NUMBER
, D.BANK_ACCOUNT_NUM BANK_ACCOUNT_NUMBER
, D.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, D.BRANCH_ID BANK_BRANCH_ID
, D.CURRENCY_CODE CURRENCY_CODE
, E.PARTY_NAME ACCOUNT_HOLDER_NAME
, C.END_DATE INACTIVE_DATE
FROM HZ_CUST_ACCOUNTS A
, IBY_EXTERNAL_PAYERS_ALL B
, IBY_PMT_INSTR_USES_ALL C
, IBY_EXT_BANK_ACCOUNTS D
, HZ_PARTIES E
, HZ_ORGANIZATION_PROFILES F
WHERE A.CUST_ACCOUNT_ID = B.CUST_ACCOUNT_ID
AND B.EXT_PAYER_ID = C.EXT_PMT_PARTY_ID
AND C.INSTRUMENT_TYPE = 'BANKACCOUNT'
AND C.INSTRUMENT_ID = D.EXT_BANK_ACCOUNT_ID
AND A.PARTY_ID = E.PARTY_ID
AND D.BANK_ID = F.PARTY_ID
AND (C.END_DATE IS NULL OR C.END_DATE > SYSDATE)
AND (D.END_DATE IS NULL OR D.END_DATE > SYSDATE) GROUP BY A.CUST_ACCOUNT_ID
, B.ORG_ID
, D.EXT_BANK_ACCOUNT_ID
, F.BANK_OR_BRANCH_NUMBER
, D.BANK_ACCOUNT_NUM
, D.BANK_ACCOUNT_NAME
, D.BRANCH_ID
, D.CURRENCY_CODE
, E.PARTY_NAME
, C.END_DATE
|
|
|
|