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 777: from hz_parties

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

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

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

Line 1447: from HZ_PARTIES h, ap_supplier_contacts a

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