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.AP_VENDOR_PARTY_MERGE_PKG dependencies on AP_SUPPLIERS

Line 54: ap_suppliers a,

50: dv.paid_invoices_flag C_PAID_INVOICES_FLAG,
51: a.segment1 C_NEW_VENDOR_NUMBER,
52: b.segment1 C_OLD_VENDOR_NUMBER
53: FROM ap_duplicate_vendors_all dv,
54: ap_suppliers a,
55: ap_suppliers b,
56: ap_supplier_sites_all c,
57: ap_supplier_sites_all d
58: WHERE dv.process_flag='S'

Line 55: ap_suppliers b,

51: a.segment1 C_NEW_VENDOR_NUMBER,
52: b.segment1 C_OLD_VENDOR_NUMBER
53: FROM ap_duplicate_vendors_all dv,
54: ap_suppliers a,
55: ap_suppliers b,
56: ap_supplier_sites_all c,
57: ap_supplier_sites_all d
58: WHERE dv.process_flag='S'
59: AND a.vendor_id=dv.vendor_id

Line 88: ap_suppliers a,

84: dv.paid_invoices_flag C_PAID_INVOICES_FLAG,
85: a.segment1 C_NEW_VENDOR_NUMBER,
86: b.segment1 C_OLD_VENDOR_NUMBER
87: FROM ap_duplicate_vendors_all dv,
88: ap_suppliers a,
89: ap_suppliers b,
90: ap_supplier_sites_all c,
91: ap_supplier_sites_all d
92: WHERE dv.process_flag in ('S','D')

Line 89: ap_suppliers b,

85: a.segment1 C_NEW_VENDOR_NUMBER,
86: b.segment1 C_OLD_VENDOR_NUMBER
87: FROM ap_duplicate_vendors_all dv,
88: ap_suppliers a,
89: ap_suppliers b,
90: ap_supplier_sites_all c,
91: ap_supplier_sites_all d
92: WHERE dv.process_flag in ('S','D')
93: AND a.vendor_id=dv.vendor_id

Line 832: l_relationship_rec.created_by_module:='AP_SUPPLIERS_API';

828: l_relationship_rec.object_table_name := 'HZ_PARTIES';
829: l_relationship_rec.relationship_code := 'CONTACT_OF';
830: l_relationship_rec.relationship_type := 'CONTACT';
831: l_relationship_rec.status := 'A';
832: l_relationship_rec.created_by_module:='AP_SUPPLIERS_API';
833:
834: IF contact_loop_c.org_contact_id is not null THEN
835:
836: select comments, contact_number, department_code,

Line 848: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';

844: l_org_contact_rec.reference_use_flag, l_org_contact_rec.rank
845: from hz_org_contacts
846: where org_contact_id = contact_loop_c.org_contact_id;
847:
848: l_org_contact_rec.created_by_module := 'AP_SUPPLIERS_API';
849: l_org_contact_rec.party_rel_rec := l_relationship_rec;
850:
851: hz_party_contact_v2pub.create_org_contact('T', l_org_contact_rec, l_org_contact_id,l_relationship_id,l_party_id,l_party_number,x_return_status,x_msg_count,x_msg_data);
852:

Line 867: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';

863: from hz_party_sites
864: where party_site_id = contact_loop_c.party_site_id;
865:
866: l_party_site_rec.location_id := l_location_id;
867: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';
868: l_party_site_rec.application_id := 200;
869: l_party_site_rec.party_id := l_party_id;
870:
871: fnd_profile.get('HZ_GENERATE_PARTY_SITE_NUMBER', l_party_site_num);

Line 961: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';

957: from hz_contact_points
958: where contact_point_id = contact_point_loop_c.contact_point_id;
959:
960: l_contact_point_rec.owner_table_id := l_party_id;
961: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';
962:
963: -- Creation of new contact points with new party_id
964: hz_contact_point_v2pub.create_contact_point('T',l_contact_point_rec,l_edi_rec,l_email_rec,l_phone_rec,l_telex_rec,l_web_rec,l_contact_point_id,x_return_status,x_msg_count,x_msg_data);
965: