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_ACCTG_DATA_FIX_PKG dependencies on PO_HEADERS_ARCHIVE_ALL

Line 6137: -- po_headers_archive_all

6133: /*=============================================================================
6134: --DESCRIPTION : this fuction will replace the new vendor contact id in place of
6135: old vendor contact id in
6136: -- po_headers_all
6137: -- po_headers_archive_all
6138: -- po_rfq_vendors
6139: -- po_vendor_list_entries
6140: -- po_requisition_lines_all
6141: -- po_reqexpress_lines_all

Line 6172: l_debug_info := 'Updating po_headers_archive_all';

6168: UPDATE po_headers_all
6169: SET vendor_contact_id = new_vendor_contact_id
6170: WHERE vendor_contact_id = old_vendor_contact_id;
6171:
6172: l_debug_info := 'Updating po_headers_archive_all';
6173: UPDATE po_headers_archive_all
6174: SET vendor_contact_id = new_vendor_contact_id
6175: WHERE vendor_contact_id = old_vendor_contact_id;
6176:

Line 6173: UPDATE po_headers_archive_all

6169: SET vendor_contact_id = new_vendor_contact_id
6170: WHERE vendor_contact_id = old_vendor_contact_id;
6171:
6172: l_debug_info := 'Updating po_headers_archive_all';
6173: UPDATE po_headers_archive_all
6174: SET vendor_contact_id = new_vendor_contact_id
6175: WHERE vendor_contact_id = old_vendor_contact_id;
6176:
6177: l_debug_info := 'Updating po_rfq_vendors';

Line 6217: -- po_headers_archive_all

6213: /*=============================================================================
6214: --DESCRIPTION : this fuction will replace the new vendor contact id in place of
6215: old vendor contact id in
6216: -- po_headers_all
6217: -- po_headers_archive_all
6218: -- po_rfq_vendors
6219: -- po_vendor_list_entries
6220: -- po_requisition_lines_all
6221: -- po_reqexpress_lines_all

Line 6265: l_debug_info := 'Updating po_headers_archive_all';

6261: ) a
6262: on (poh.po_header_id = a.po_header_id)
6263: WHEN MATCHED THEN UPDATE SET poh.vendor_contact_id = a.new_vendor_contact_id';
6264:
6265: l_debug_info := 'Updating po_headers_archive_all';
6266:
6267: EXECUTE IMMEDIATE
6268: 'MERGE INTO po_headers_archive_all poh
6269: USING (SELECT DISTINCT poh.po_header_id,

Line 6268: 'MERGE INTO po_headers_archive_all poh

6264:
6265: l_debug_info := 'Updating po_headers_archive_all';
6266:
6267: EXECUTE IMMEDIATE
6268: 'MERGE INTO po_headers_archive_all poh
6269: USING (SELECT DISTINCT poh.po_header_id,
6270: poh.revision_num,
6271: tmp.new_vendor_contact_id,
6272: tmp.current_vendor_contact_id

Line 6274: 'po_headers_archive_all poh

6270: poh.revision_num,
6271: tmp.new_vendor_contact_id,
6272: tmp.current_vendor_contact_id
6273: FROM '|| p_driver_table || ' tmp,'||
6274: 'po_headers_archive_all poh
6275: WHERE poh.vendor_contact_id = tmp.current_vendor_contact_id
6276: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6277: and tmp.process_flag = ''Y''
6278: ) a