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.ITG_SYNCSUPPLIERINBOUND_PVT dependencies on HZ_PARTIES

Line 775: from hz_parties

771: duns_number_c
772: into l_party_object_version_number,
773: l_party_number,
774: l_duns_number
775: from hz_parties
776: where party_id=l_party_id;
777:
778: IF (l_Debug_Level <= 1) THEN
779: itg_debug_pub.Add('party_id - '|| l_party_id,1);

Line 789: itg_debug_pub.Add('Couldn''t find party_id from ap_suppliers or obj_ver,party_num,duns_num from hz_parties ');

785:
786: EXCEPTION
787: WHEN NO_DATA_FOUND THEN
788: IF (l_Debug_Level <= 1) THEN
789: itg_debug_pub.Add('Couldn''t find party_id from ap_suppliers or obj_ver,party_num,duns_num from hz_parties ');
790: END IF;
791: RAISE FND_API.G_EXC_ERROR;
792: END;
793:

Line 1445: from HZ_PARTIES h, ap_supplier_contacts a

1441: g_action := 'Vendor-contact information sync';
1442:
1443: select h.party_id, h.object_version_number
1444: into l_party_id,l_obj_ver_num
1445: from HZ_PARTIES h, ap_supplier_contacts a
1446: where a.per_party_id = h.party_id
1447: and a.vendor_site_id = l_vsite_id
1448: AND NVL(upper(person_first_name), '1') = NVL(upper(p_first_name), '1')
1449: AND NVL(upper(person_middle_name), '1') = NVL(upper(p_middle_name), '1')