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_PARTIES

Line 71: FROM hz_parties hz_bank,

67: SELECT hz_bank.party_id AS bank_id,
68: hz_bankorg.home_country,
69: hz_bank.party_name,
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,

Line 73: hz_parties hz_branch,

69: hz_bank.party_name,
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'

Line 77: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

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
79: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
80: AND hz_branchCA.class_code = 'BANK_BRANCH'
81: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 84: AND hz_bankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

80: AND hz_branchCA.class_code = 'BANK_BRANCH'
81: AND NVL(hz_branchCA.STATUS, 'A') = 'A'
82: AND hz_bankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
83: AND hz_bankCA.CLASS_CODE = 'BANK'
84: AND hz_bankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
85: AND hz_bankCA.OWNER_TABLE_ID = hz_bank.PARTY_ID
86: AND NVL(hz_bankCA.STATUS, 'A') = 'A'
87: AND hz_rel.OBJECT_ID = hz_bank.PARTY_ID
88: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID

Line 92: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

88: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
89: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
90: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
91: And hz_rel.STATUS = 'A'
92: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
93: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
94: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
95: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
96: AND hz_bank.party_id = hz_bankorg.party_id

Line 94: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

90: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
91: And hz_rel.STATUS = 'A'
92: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
93: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
94: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
95: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
96: AND hz_bank.party_id = hz_bankorg.party_id
97: AND SYSDATE between TRUNC(hz_bankorg.effective_start_date)
98: and NVL(TRUNC(hz_bankorg.effective_end_date), SYSDATE+1)

Line 521: AND owner_table_name = 'HZ_PARTIES'

517: SELECT object_version_number
518: INTO l_ca_object_version_number
519: FROM hz_code_assignments
520: WHERE class_category= 'BANK_INSTITUTION_TYPE'
521: AND owner_table_name = 'HZ_PARTIES'
522: AND owner_table_id = p_bank_id
523: AND status = 'A';
524:
525: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

Line 624: WHERE owner_table_name = 'HZ_PARTIES'

620: ) IS
621: CURSOR c_bank IS
622: SELECT end_date_active
623: FROM hz_code_assignments
624: WHERE owner_table_name = 'HZ_PARTIES'
625: AND owner_table_id = p_bank_id
626: AND class_category = 'BANK_INSTITUTION_TYPE'
627: AND class_code = 'BANK';
628: CURSOR c_branch_id IS

Line 633: AND subject_table_name = 'HZ_PARTIES'

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'
635: AND object_table_name = 'HZ_PARTIES'
636: AND object_type = 'ORGANIZATION'
637: AND object_id = p_bank_id;

Line 635: AND object_table_name = 'HZ_PARTIES'

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'
635: AND object_table_name = 'HZ_PARTIES'
636: AND object_type = 'ORGANIZATION'
637: AND object_id = p_bank_id;
638: CURSOR c_branch (p_branch_id NUMBER) IS
639: SELECT end_date_active, object_version_number

Line 641: WHERE owner_table_name = 'HZ_PARTIES'

637: AND object_id = p_bank_id;
638: CURSOR c_branch (p_branch_id NUMBER) IS
639: SELECT end_date_active, object_version_number
640: FROM hz_code_assignments
641: WHERE owner_table_name = 'HZ_PARTIES'
642: AND owner_table_id = p_branch_id
643: AND class_category = 'BANK_INSTITUTION_TYPE'
644: AND class_code = 'BANK_BRANCH';
645: CURSOR c_bank_ovn IS

Line 647: FROM hz_parties

643: AND class_category = 'BANK_INSTITUTION_TYPE'
644: AND class_code = 'BANK_BRANCH';
645: CURSOR c_bank_ovn IS
646: SELECT object_version_number
647: FROM hz_parties
648: WHERE party_id = p_bank_id;
649:
650: l_bank_end DATE;
651: l_branch_end DATE;

Line 829: FROM hz_parties hz_hp,

825: ) IS
826: CURSOR c_bank_name IS
827: SELECT hz_hp.party_id,
828: hz_ca.end_date_active
829: FROM hz_parties hz_hp,
830: hz_organization_profiles hz_org,
831: hz_code_assignments hz_ca
832: WHERE hz_ca.owner_table_id = hz_hp.party_id
833: AND hz_ca.owner_table_name = 'HZ_PARTIES'

Line 833: AND hz_ca.owner_table_name = 'HZ_PARTIES'

829: FROM hz_parties hz_hp,
830: hz_organization_profiles hz_org,
831: hz_code_assignments hz_ca
832: WHERE hz_ca.owner_table_id = hz_hp.party_id
833: AND hz_ca.owner_table_name = 'HZ_PARTIES'
834: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
835: AND hz_ca.class_code = 'BANK'
836: AND hz_hp.PARTY_ID = hz_org.PARTY_ID
837: AND SYSDATE between TRUNC(hz_org.effective_start_date)

Line 845: FROM hz_parties hz_hp,

841:
842: CURSOR c_bank_num IS
843: SELECT hz_hp.party_id,
844: hz_ca.end_date_active
845: FROM hz_parties hz_hp,
846: hz_organization_profiles hz_hop,
847: hz_code_assignments hz_ca
848: WHERE hz_hp.party_id = hz_hop.party_id
849: AND SYSDATE between TRUNC(hz_hop.effective_start_date)

Line 852: AND hz_ca.owner_table_name = 'HZ_PARTIES'

848: WHERE hz_hp.party_id = hz_hop.party_id
849: AND SYSDATE between TRUNC(hz_hop.effective_start_date)
850: and NVL(TRUNC(hz_hop.effective_end_date), SYSDATE+1)
851: AND hz_ca.owner_table_id = hz_hp.party_id
852: AND hz_ca.owner_table_name = 'HZ_PARTIES'
853: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
854: AND hz_ca.class_code = 'BANK'
855: AND hz_hp.country = p_country_code
856: AND hz_hop.bank_or_branch_number = p_bank_number;

Line 974: FROM hz_parties hz_p,

970: x_msg_data OUT NOCOPY VARCHAR2
971: ) IS
972: CURSOR c_bank IS
973: SELECT hz_p.party_name, hz_org.bank_or_branch_number
974: FROM hz_parties hz_p,
975: hz_organization_profiles hz_org
976: WHERE hz_p.party_id = hz_org.party_id
977: AND SYSDATE between TRUNC(hz_org.effective_start_date)
978: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)

Line 1124: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1120: END IF;
1121:
1122: IF p_bic IS NOT NULL OR p_eft_number IS NOT NULL THEN
1123: l_contact_point_rec.contact_point_type := 'EFT';
1124: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1125: l_contact_point_rec.owner_table_id := x_branch_id;
1126: l_contact_point_rec.created_by_module := 'CE';
1127:
1128: l_eft_rec.eft_swift_code := p_bic;

Line 1279: AND owner_table_name = 'HZ_PARTIES'

1275: CURSOR c_eft IS
1276: SELECT contact_point_id
1277: FROM hz_contact_points
1278: WHERE contact_point_type = 'EFT'
1279: AND owner_table_name = 'HZ_PARTIES'
1280: AND owner_table_id = p_branch_id;
1281:
1282: l_branch_rec hz_bank_pub.bank_rec_type;
1283: l_org_rec hz_party_v2pub.organization_rec_type;

Line 1406: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';

1402:
1403: IF c_eft%NOTFOUND THEN -- does not already have eft contact points
1404: IF p_bic IS NOT NULL OR p_eft_number IS NOT NULL THEN
1405: l_contact_point_rec.contact_point_type := 'EFT';
1406: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1407: l_contact_point_rec.owner_table_id := p_branch_id;
1408: l_contact_point_rec.created_by_module := 'CE';
1409:
1410: l_eft_rec.eft_swift_code := p_bic;

Line 1526: WHERE owner_table_name = 'HZ_PARTIES'

1522: ) IS
1523: CURSOR c_bank (p_bank_id NUMBER) IS
1524: SELECT end_date_active, object_version_number
1525: FROM hz_code_assignments
1526: WHERE owner_table_name = 'HZ_PARTIES'
1527: AND owner_table_id = p_bank_id
1528: AND class_category = 'BANK_INSTITUTION_TYPE'
1529: AND class_code = 'BANK';
1530: CURSOR c_bank_id IS

Line 1535: AND subject_table_name = 'HZ_PARTIES'

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'
1537: AND object_table_name = 'HZ_PARTIES'
1538: AND object_type = 'ORGANIZATION'
1539: AND subject_id = p_branch_id;

Line 1537: AND object_table_name = 'HZ_PARTIES'

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'
1537: AND object_table_name = 'HZ_PARTIES'
1538: AND object_type = 'ORGANIZATION'
1539: AND subject_id = p_branch_id;
1540: CURSOR c_branch_end IS
1541: SELECT end_date_active

Line 1543: WHERE owner_table_name = 'HZ_PARTIES'

1539: AND subject_id = p_branch_id;
1540: CURSOR c_branch_end IS
1541: SELECT end_date_active
1542: FROM hz_code_assignments
1543: WHERE owner_table_name = 'HZ_PARTIES'
1544: AND owner_table_id = p_branch_id
1545: AND class_category = 'BANK_INSTITUTION_TYPE'
1546: AND class_code = 'BANK_BRANCH';
1547: CURSOR c_branch_party_ovn IS

Line 1549: FROM hz_parties

1545: AND class_category = 'BANK_INSTITUTION_TYPE'
1546: AND class_code = 'BANK_BRANCH';
1547: CURSOR c_branch_party_ovn IS
1548: SELECT object_version_number
1549: FROM hz_parties
1550: WHERE party_id = p_branch_id;
1551: CURSOR c_account IS
1552: SELECT bank_account_id, start_date, end_date, object_version_number
1553: FROM ce_bank_accounts

Line 1558: WHERE owner_table_name = 'HZ_PARTIES'

1554: WHERE bank_branch_id = p_branch_id;
1555: CURSOR c_rfc_ovn IS
1556: SELECT object_version_number
1557: FROM hz_code_assignments
1558: WHERE owner_table_name = 'HZ_PARTIES'
1559: AND owner_table_id = p_branch_id
1560: AND class_category = 'RFC_IDENTIFIER';
1561:
1562: l_bank_id NUMBER(15);

Line 1794: FROM hz_parties hz_branch,

1790: ) IS
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

Line 1797: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

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'
1800: AND hz_branchCA.class_code = 'BANK_BRANCH'
1801: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 1807: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1803: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
1804: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
1805: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1806: And hz_rel.STATUS = 'A'
1807: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1808: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1809: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1810: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1811: AND upper(hz_branch.party_name) = upper(p_branch_name);

Line 1809: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1805: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1806: And hz_rel.STATUS = 'A'
1807: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1808: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1809: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1810: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1811: AND upper(hz_branch.party_name) = upper(p_branch_name);
1812:
1813: CURSOR c_branch_num IS

Line 1816: FROM hz_parties hz_branch,

1812:
1813: CURSOR c_branch_num IS
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'

Line 1820: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

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'
1823: AND hz_branchCA.class_code = 'BANK_BRANCH'
1824: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 1830: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1826: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
1827: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
1828: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1829: And hz_rel.STATUS = 'A'
1830: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1831: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1832: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1833: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1834: AND hz_branch.party_id = hz_branchProf.party_id

Line 1832: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1828: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1829: And hz_rel.STATUS = 'A'
1830: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1831: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1832: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1833: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1834: AND hz_branch.party_id = hz_branchProf.party_id
1835: AND SYSDATE between TRUNC(hz_branchProf.effective_start_date)
1836: and NVL(TRUNC(hz_branchProf.effective_end_date), SYSDATE+1)