eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BANK_PUB dependencies on HZ_RELATIONSHIPS

Line 74: hz_relationships hz_rel,

70: hz_bankorg.bank_or_branch_number
71: FROM hz_parties hz_bank,
72: hz_organization_profiles hz_bankorg,
73: hz_parties hz_branch,
74: hz_relationships hz_rel,
75: hz_code_assignments hz_bankCA,
76: hz_code_assignments hz_branchCA
77: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
78: AND hz_branchCA.owner_table_id = hz_branch.party_id

Line 630: FROM hz_relationships

626: AND class_category = 'BANK_INSTITUTION_TYPE'
627: AND class_code = 'BANK';
628: CURSOR c_branch_id IS
629: SELECT subject_id
630: FROM hz_relationships
631: WHERE relationship_type = 'BANK_AND_BRANCH'
632: AND relationship_code = 'BRANCH_OF'
633: AND subject_table_name = 'HZ_PARTIES'
634: AND subject_type = 'ORGANIZATION'

Line 1532: FROM hz_relationships

1528: AND class_category = 'BANK_INSTITUTION_TYPE'
1529: AND class_code = 'BANK';
1530: CURSOR c_bank_id IS
1531: SELECT object_id
1532: FROM hz_relationships
1533: WHERE relationship_type = 'BANK_AND_BRANCH'
1534: AND relationship_code = 'BRANCH_OF'
1535: AND subject_table_name = 'HZ_PARTIES'
1536: AND subject_type = 'ORGANIZATION'

Line 1795: hz_relationships hz_rel,

1791: CURSOR c_branch_name IS
1792: SELECT hz_branch.party_id,
1793: hz_branchCA.end_date_active
1794: FROM hz_parties hz_branch,
1795: hz_relationships hz_rel,
1796: hz_code_assignments hz_branchCA
1797: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1798: AND hz_branchCA.owner_table_id = hz_branch.party_id
1799: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 1818: hz_relationships hz_rel,

1814: SELECT hz_branch.party_id,
1815: hz_branchCA.end_date_active
1816: FROM hz_parties hz_branch,
1817: hz_organization_profiles hz_branchProf,
1818: hz_relationships hz_rel,
1819: hz_code_assignments hz_branchCA
1820: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1821: AND hz_branchCA.owner_table_id = hz_branch.party_id
1822: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'

Line 1925: FROM hz_relationships

1921: AND party_id = p_acct_rec.branch_id;
1922: /*
1923: CURSOR c_bank_id IS
1924: SELECT object_id
1925: FROM hz_relationships
1926: WHERE RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
1927: AND RELATIONSHIP_CODE = 'BRANCH_OF'
1928: AND subject_id = p_acct_rec.branch_id;
1929: */