Posts Tagged ‘SQL for Active Banks and Branches in EBS R12’

SQL for Active Banks and Branches in EBS R12

January 21st, 2020, posted in Oracle Queries
Share
SELECT BankOrgProfile.*SQL for Active Banks and Branches in EBS R12,SQL for Active Banks and Branches in Oracle EBS R12,SQL for Active Banks and Branches in Oracle,Oracle Query,Oracle DBA,DBA Query,SQL for Active Bank and Branche in Oracle,

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 :
Share