Query : Get Bank Information from HZ Tables

select * from
hz_parties bankparty, hz_code_assignments bankca
where
bankparty.party_type = 'ORGANIZATION'
AND bankca.class_category = 'BANK_INSTITUTION_TYPE'
AND bankca.class_code IN ('BANK', 'CLEARINGHOUSE')
AND bankca.owner_table_name = 'HZ_PARTIES'
AND bankca.owner_table_id = bankparty.party_id
AND NVL (bankca.status, 'A') = 'A'

0 comments:

Post a Comment