SELECT BankOrgProfile.*
FROM HZ_ORGANIZATION_PROFILES BankOrgProfile, HZ_CODE_ASSIGNMENTS BankCA
WHERE 1 = 1
AND SYSDATE BETWEEN TRUNC (BankOrgProfile.effective_start_date)
AND NVL (TRUNC (BankOrgProfile.effective_end_date),
SYSDATE + 1)
AND BankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
AND BankCA.CLASS_CODE IN ('BANK', 'CLEARINGHOUSE')
AND BankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND (BankCA.STATUS = 'A' OR BankCA.STATUS IS NULL)
AND BankCA.OWNER_TABLE_ID = BankOrgProfile.PARTY_ID :
Comments
comments
Tags: DBA Query, Oracle DBA, Oracle Query, SQL for Active Bank and Branche in Oracle, SQL for Active Banks and Branches in EBS R12, SQL for Active Banks and Branches in Oracle, SQL for Active Banks and Branches in Oracle EBS R12
This entry was posted
on Tuesday, January 21st, 2020 at 12:01 am and is filed under Oracle Queries.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
