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 101: FROM hz_parties hz_bank,

97: SELECT hz_bank.party_id AS bank_id,
98: hz_bankorg.home_country,
99: hz_bank.party_name,
100: hz_bankorg.bank_or_branch_number
101: FROM hz_parties hz_bank,
102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,

Line 103: hz_parties hz_branch,

99: hz_bank.party_name,
100: hz_bankorg.bank_or_branch_number
101: FROM hz_parties hz_bank,
102: hz_organization_profiles hz_bankorg,
103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

Line 107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

103: hz_parties hz_branch,
104: hz_relationships hz_rel,
105: hz_code_assignments hz_bankCA,
106: hz_code_assignments hz_branchCA
107: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
108: AND hz_branchCA.owner_table_id = hz_branch.party_id
109: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
110: AND hz_branchCA.class_code = 'BANK_BRANCH'
111: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 114: AND hz_bankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'

110: AND hz_branchCA.class_code = 'BANK_BRANCH'
111: AND NVL(hz_branchCA.STATUS, 'A') = 'A'
112: AND hz_bankCA.CLASS_CATEGORY = 'BANK_INSTITUTION_TYPE'
113: AND hz_bankCA.CLASS_CODE = 'BANK'
114: AND hz_bankCA.OWNER_TABLE_NAME = 'HZ_PARTIES'
115: AND hz_bankCA.OWNER_TABLE_ID = hz_bank.PARTY_ID
116: AND NVL(hz_bankCA.STATUS, 'A') = 'A'
117: AND hz_rel.OBJECT_ID = hz_bank.PARTY_ID
118: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID

Line 122: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

118: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
119: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
120: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
121: And hz_rel.STATUS = 'A'
122: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
123: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
124: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
125: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
126: AND hz_bank.party_id = hz_bankorg.party_id

Line 124: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

120: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
121: And hz_rel.STATUS = 'A'
122: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
123: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
124: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
125: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
126: AND hz_bank.party_id = hz_bankorg.party_id
127: AND SYSDATE between TRUNC(hz_bankorg.effective_start_date)
128: and NVL(TRUNC(hz_bankorg.effective_end_date), SYSDATE+1)

Line 549: AND owner_table_name = 'HZ_PARTIES'

545: SELECT object_version_number
546: INTO l_ca_object_version_number
547: FROM hz_code_assignments
548: WHERE class_category= 'BANK_INSTITUTION_TYPE'
549: AND owner_table_name = 'HZ_PARTIES'
550: AND owner_table_id = p_bank_id
551: AND status = 'A';
552:
553: hz_bank_pub.update_bank(fnd_api.g_false, l_bank_rec,

Line 652: WHERE owner_table_name = 'HZ_PARTIES'

648: ) IS
649: CURSOR c_bank IS
650: SELECT end_date_active
651: FROM hz_code_assignments
652: WHERE owner_table_name = 'HZ_PARTIES'
653: AND owner_table_id = p_bank_id
654: AND class_category = 'BANK_INSTITUTION_TYPE'
655: AND class_code = 'BANK';
656: CURSOR c_branch_id IS

Line 661: AND subject_table_name = 'HZ_PARTIES'

657: SELECT subject_id
658: FROM hz_relationships
659: WHERE relationship_type = 'BANK_AND_BRANCH'
660: AND relationship_code = 'BRANCH_OF'
661: AND subject_table_name = 'HZ_PARTIES'
662: AND subject_type = 'ORGANIZATION'
663: AND object_table_name = 'HZ_PARTIES'
664: AND object_type = 'ORGANIZATION'
665: AND object_id = p_bank_id;

Line 663: AND object_table_name = 'HZ_PARTIES'

659: WHERE relationship_type = 'BANK_AND_BRANCH'
660: AND relationship_code = 'BRANCH_OF'
661: AND subject_table_name = 'HZ_PARTIES'
662: AND subject_type = 'ORGANIZATION'
663: AND object_table_name = 'HZ_PARTIES'
664: AND object_type = 'ORGANIZATION'
665: AND object_id = p_bank_id;
666: CURSOR c_branch (p_branch_id NUMBER) IS
667: SELECT end_date_active, object_version_number

Line 669: WHERE owner_table_name = 'HZ_PARTIES'

665: AND object_id = p_bank_id;
666: CURSOR c_branch (p_branch_id NUMBER) IS
667: SELECT end_date_active, object_version_number
668: FROM hz_code_assignments
669: WHERE owner_table_name = 'HZ_PARTIES'
670: AND owner_table_id = p_branch_id
671: AND class_category = 'BANK_INSTITUTION_TYPE'
672: AND class_code = 'BANK_BRANCH';
673: CURSOR c_bank_ovn IS

Line 675: FROM hz_parties

671: AND class_category = 'BANK_INSTITUTION_TYPE'
672: AND class_code = 'BANK_BRANCH';
673: CURSOR c_bank_ovn IS
674: SELECT object_version_number
675: FROM hz_parties
676: WHERE party_id = p_bank_id;
677:
678: l_bank_end DATE;
679: l_branch_end DATE;

Line 853: FROM hz_parties hz_hp,

849: ) IS
850: CURSOR c_bank_name IS
851: SELECT hz_hp.party_id,
852: hz_ca.end_date_active
853: FROM hz_parties hz_hp,
854: hz_organization_profiles hz_org,
855: hz_code_assignments hz_ca
856: WHERE hz_ca.owner_table_id = hz_hp.party_id
857: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484

Line 859: AND hz_ca.owner_table_name = 'HZ_PARTIES'

855: hz_code_assignments hz_ca
856: WHERE hz_ca.owner_table_id = hz_hp.party_id
857: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484
858: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
859: AND hz_ca.owner_table_name = 'HZ_PARTIES'
860: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
861: AND hz_ca.class_code = 'BANK'
862: AND hz_hp.PARTY_ID = hz_org.PARTY_ID
863: AND SYSDATE between TRUNC(hz_org.effective_start_date)

Line 871: FROM hz_parties hz_hp,

867:
868: CURSOR c_bank_num IS
869: SELECT hz_hp.party_id,
870: hz_ca.end_date_active
871: FROM hz_parties hz_hp,
872: hz_organization_profiles hz_hop,
873: hz_code_assignments hz_ca
874: WHERE hz_hp.party_id = hz_hop.party_id
875: AND hz_hp.party_type = 'ORGANIZATION' -- Bug 8333484

Line 880: AND hz_ca.owner_table_name = 'HZ_PARTIES'

876: AND NVL(hz_hp.status, 'A') = 'A' -- Bug 8333484
877: AND SYSDATE between TRUNC(hz_hop.effective_start_date)
878: and NVL(TRUNC(hz_hop.effective_end_date), SYSDATE+1)
879: AND hz_ca.owner_table_id = hz_hp.party_id
880: AND hz_ca.owner_table_name = 'HZ_PARTIES'
881: AND hz_ca.class_category = 'BANK_INSTITUTION_TYPE'
882: AND hz_ca.class_code = 'BANK'
883: AND hz_hop.home_country = p_country_code -- Bug 8992915
884: AND hz_hop.bank_or_branch_number = p_bank_number;

Line 1002: FROM hz_parties hz_p,

998: x_msg_data OUT NOCOPY VARCHAR2
999: ) IS
1000: CURSOR c_bank IS
1001: SELECT hz_p.party_name, hz_org.bank_or_branch_number
1002: FROM hz_parties hz_p,
1003: hz_organization_profiles hz_org
1004: WHERE hz_p.party_id = hz_org.party_id
1005: AND SYSDATE between TRUNC(hz_org.effective_start_date)
1006: and NVL(TRUNC(hz_org.effective_end_date), SYSDATE+1)

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

1173: END IF;
1174:
1175: IF p_bic IS NOT NULL OR p_eft_number IS NOT NULL THEN
1176: l_contact_point_rec.contact_point_type := 'EFT';
1177: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1178: l_contact_point_rec.owner_table_id := x_branch_id;
1179: l_contact_point_rec.created_by_module := 'CE';
1180:
1181: l_eft_rec.eft_swift_code := p_bic;

Line 1336: AND owner_table_name = 'HZ_PARTIES'

1332: CURSOR c_eft IS
1333: SELECT contact_point_id
1334: FROM hz_contact_points
1335: WHERE contact_point_type = 'EFT'
1336: AND owner_table_name = 'HZ_PARTIES'
1337: AND owner_table_id = p_branch_id;
1338:
1339: l_branch_rec hz_bank_pub.bank_rec_type;
1340: l_org_rec hz_party_v2pub.organization_rec_type;

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

1485:
1486: IF c_eft%NOTFOUND THEN -- does not already have eft contact points
1487: IF p_bic IS NOT NULL OR p_eft_number IS NOT NULL THEN
1488: l_contact_point_rec.contact_point_type := 'EFT';
1489: l_contact_point_rec.owner_table_name := 'HZ_PARTIES';
1490: l_contact_point_rec.owner_table_id := p_branch_id;
1491: l_contact_point_rec.created_by_module := 'CE';
1492:
1493: l_eft_rec.eft_swift_code := p_bic;

Line 1612: WHERE owner_table_name = 'HZ_PARTIES'

1608:
1609: CURSOR c_bank (p_bank_id NUMBER) IS
1610: SELECT end_date_active, object_version_number
1611: FROM hz_code_assignments
1612: WHERE owner_table_name = 'HZ_PARTIES'
1613: AND owner_table_id = p_bank_id
1614: AND class_category = 'BANK_INSTITUTION_TYPE'
1615: AND class_code = 'BANK';
1616:

Line 1622: AND subject_table_name = 'HZ_PARTIES'

1618: SELECT object_id
1619: FROM hz_relationships
1620: WHERE relationship_type = 'BANK_AND_BRANCH'
1621: AND relationship_code = 'BRANCH_OF'
1622: AND subject_table_name = 'HZ_PARTIES'
1623: AND subject_type = 'ORGANIZATION'
1624: AND object_table_name = 'HZ_PARTIES'
1625: AND object_type = 'ORGANIZATION'
1626: AND subject_id = p_branch_id;

Line 1624: AND object_table_name = 'HZ_PARTIES'

1620: WHERE relationship_type = 'BANK_AND_BRANCH'
1621: AND relationship_code = 'BRANCH_OF'
1622: AND subject_table_name = 'HZ_PARTIES'
1623: AND subject_type = 'ORGANIZATION'
1624: AND object_table_name = 'HZ_PARTIES'
1625: AND object_type = 'ORGANIZATION'
1626: AND subject_id = p_branch_id;
1627:
1628: CURSOR c_branch_end IS

Line 1631: WHERE owner_table_name = 'HZ_PARTIES'

1627:
1628: CURSOR c_branch_end IS
1629: SELECT end_date_active
1630: FROM hz_code_assignments
1631: WHERE owner_table_name = 'HZ_PARTIES'
1632: AND owner_table_id = p_branch_id
1633: AND class_category = 'BANK_INSTITUTION_TYPE'
1634: AND class_code = 'BANK_BRANCH';
1635:

Line 1638: FROM hz_parties

1634: AND class_code = 'BANK_BRANCH';
1635:
1636: CURSOR c_branch_party_ovn IS
1637: SELECT object_version_number
1638: FROM hz_parties
1639: WHERE party_id = p_branch_id;
1640:
1641: -- 12557532: renamed cursor c_account => c_internal_accounts
1642: CURSOR c_internal_account IS

Line 1656: WHERE owner_table_name = 'HZ_PARTIES'

1652:
1653: CURSOR c_rfc_ovn IS
1654: SELECT object_version_number
1655: FROM hz_code_assignments
1656: WHERE owner_table_name = 'HZ_PARTIES'
1657: AND owner_table_id = p_branch_id
1658: AND class_category = 'RFC_IDENTIFIER';
1659:
1660: l_bank_id NUMBER(15);

Line 1933: FROM hz_parties hz_branch,

1929: ) IS
1930: CURSOR c_branch_name IS
1931: SELECT hz_branch.party_id,
1932: hz_branchCA.end_date_active
1933: FROM hz_parties hz_branch,
1934: hz_relationships hz_rel,
1935: hz_code_assignments hz_branchCA
1936: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1937: AND hz_branchCA.owner_table_id = hz_branch.party_id

Line 1936: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

1932: hz_branchCA.end_date_active
1933: FROM hz_parties hz_branch,
1934: hz_relationships hz_rel,
1935: hz_code_assignments hz_branchCA
1936: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1937: AND hz_branchCA.owner_table_id = hz_branch.party_id
1938: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1939: AND hz_branchCA.class_code = 'BANK_BRANCH'
1940: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 1946: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1942: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
1943: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
1944: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1945: And hz_rel.STATUS = 'A'
1946: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1947: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1948: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1949: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1950: AND upper(hz_branch.party_name) = upper(p_branch_name);

Line 1948: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1944: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1945: And hz_rel.STATUS = 'A'
1946: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1947: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1948: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1949: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1950: AND upper(hz_branch.party_name) = upper(p_branch_name);
1951:
1952: CURSOR c_branch_num IS

Line 1955: FROM hz_parties hz_branch,

1951:
1952: CURSOR c_branch_num IS
1953: SELECT hz_branch.party_id,
1954: hz_branchCA.end_date_active
1955: FROM hz_parties hz_branch,
1956: hz_organization_profiles hz_branchProf,
1957: hz_relationships hz_rel,
1958: hz_code_assignments hz_branchCA
1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

Line 1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'

1955: FROM hz_parties hz_branch,
1956: hz_organization_profiles hz_branchProf,
1957: hz_relationships hz_rel,
1958: hz_code_assignments hz_branchCA
1959: WHERE hz_branchCA.owner_table_name = 'HZ_PARTIES'
1960: AND hz_branchCA.owner_table_id = hz_branch.party_id
1961: AND hz_branchCA.class_category = 'BANK_INSTITUTION_TYPE'
1962: AND hz_branchCA.class_code = 'BANK_BRANCH'
1963: AND NVL(hz_branchCA.STATUS, 'A') = 'A'

Line 1969: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1965: And hz_branch.PARTY_ID = hz_rel.SUBJECT_ID
1966: And hz_rel.RELATIONSHIP_TYPE = 'BANK_AND_BRANCH'
1967: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1968: And hz_rel.STATUS = 'A'
1969: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1970: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1971: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1972: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1973: AND hz_branch.party_id = hz_branchProf.party_id

Line 1971: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1967: And hz_rel.RELATIONSHIP_CODE = 'BRANCH_OF'
1968: And hz_rel.STATUS = 'A'
1969: And hz_rel.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1970: And hz_rel.SUBJECT_TYPE = 'ORGANIZATION'
1971: And hz_rel.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1972: And hz_rel.OBJECT_TYPE = 'ORGANIZATION'
1973: AND hz_branch.party_id = hz_branchProf.party_id
1974: AND SYSDATE between TRUNC(hz_branchProf.effective_start_date)
1975: and NVL(TRUNC(hz_branchProf.effective_end_date), SYSDATE+1)