SELECT DISTINCT fou.set_of_books_id, cba.agency_location_code FROM CE_BANK_ACCOUNTS cba, CE_BANK_ACCT_USES_ALL ceba, FV_OPERATING_UNITS_ALL fou where cba.bank_account_id = ceba.bank_account_id and cba.account_classification ='INTERNAL' and fou.organization_id=ceba.org_id and cba.agency_location_code is not null UNION SELECT -1, 'ALL' FROM Dual
SELECT DISTINCT FOU.SET_OF_BOOKS_ID
, CBA.AGENCY_LOCATION_CODE
FROM CE_BANK_ACCOUNTS CBA
, CE_BANK_ACCT_USES_ALL CEBA
, FV_OPERATING_UNITS_ALL FOU
WHERE CBA.BANK_ACCOUNT_ID = CEBA.BANK_ACCOUNT_ID
AND CBA.ACCOUNT_CLASSIFICATION ='INTERNAL'
AND FOU.ORGANIZATION_ID=CEBA.ORG_ID
AND CBA.AGENCY_LOCATION_CODE IS NOT NULL UNION SELECT -1
, 'ALL'
FROM DUAL
|
|
|