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_REQEXPRESS_LINES_ALL

Line 6141: -- po_reqexpress_lines_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
6142: -- This function returns a 1 if it is successful. It returns a 0
6143: -- if there are exceptions.
6144: --PARAMETERS : new_vendor_contact_id - this is the new vendor contact id that
6145: -- will be used to replace the old one

Line 6192: l_debug_info := 'Updating po_reqexpress_lines_all';

6188: UPDATE po_requisition_lines_all
6189: SET vendor_contact_id = new_vendor_contact_id
6190: WHERE vendor_contact_id = old_vendor_contact_id;
6191:
6192: l_debug_info := 'Updating po_reqexpress_lines_all';
6193: UPDATE po_reqexpress_lines_all
6194: SET suggested_vendor_contact_id = new_vendor_contact_id
6195: WHERE suggested_vendor_contact_id = old_vendor_contact_id;
6196:

Line 6193: UPDATE po_reqexpress_lines_all

6189: SET vendor_contact_id = new_vendor_contact_id
6190: WHERE vendor_contact_id = old_vendor_contact_id;
6191:
6192: l_debug_info := 'Updating po_reqexpress_lines_all';
6193: UPDATE po_reqexpress_lines_all
6194: SET suggested_vendor_contact_id = new_vendor_contact_id
6195: WHERE suggested_vendor_contact_id = old_vendor_contact_id;
6196:
6197: RETURN 1;

Line 6221: -- po_reqexpress_lines_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
6222: -- This function returns a 1 if it is successful. It returns a 0
6223: -- if there are exceptions.
6224: --PARAMETERS : p_bug_no - GDF bug that is calling the fix
6225: -- p_driver_table - GDF driver table that stores the dupciate

Line 6331: l_debug_info := 'Updating po_reqexpress_lines_all';

6327: ) a
6328: on (poh.requisition_line_id = a.requisition_line_id)
6329: WHEN MATCHED THEN UPDATE SET poh.vendor_contact_id = a.new_vendor_contact_id';
6330:
6331: l_debug_info := 'Updating po_reqexpress_lines_all';
6332:
6333: EXECUTE IMMEDIATE
6334: 'MERGE INTO po_reqexpress_lines_all poh
6335: USING (SELECT distinct

Line 6334: 'MERGE INTO po_reqexpress_lines_all poh

6330:
6331: l_debug_info := 'Updating po_reqexpress_lines_all';
6332:
6333: EXECUTE IMMEDIATE
6334: 'MERGE INTO po_reqexpress_lines_all poh
6335: USING (SELECT distinct
6336: poh.rowid row_id, --bug13863902
6337: poh.express_name,
6338: poh.sequence_num,

Line 6342: 'po_reqexpress_lines_all poh

6338: poh.sequence_num,
6339: tmp.new_vendor_contact_id,
6340: tmp.current_vendor_contact_id
6341: FROM '|| p_driver_table || ' tmp,'||
6342: 'po_reqexpress_lines_all poh
6343: WHERE poh.suggested_vendor_contact_id = tmp.current_vendor_contact_id
6344: and tmp.current_vendor_contact_id <> tmp.new_vendor_contact_id --bug13863902
6345: AND tmp.process_flag = ''Y''
6346: ) a