APPS.PO_AP_MERGE_GRP dependencies on PO_REQEXPRESS_LINES_ALL

Line 1088: --Modifies: po_reqexpress_lines_all

1084: -----------------------------------------------------------------------
1085: --Start of Comments
1086: --Name: update_req_temp_vdr_info
1087: --Pre-reqs:
1088: --Modifies: po_reqexpress_lines_all
1089: --Locks:
1090: -- None
1091: --Function:
1092: -- Update requisition template in all OU with the new supplier information

Line 1134: UPDATE po_reqexpress_lines_all PRL

1130: l_progress := '000';
1131:
1132: -- Update Req Template Records
1133:
1134: UPDATE po_reqexpress_lines_all PRL
1135: SET PRL.suggested_vendor_id = p_to_vendor_id,
1136: PRL.suggested_vendor_site_id = p_to_site_id,
1137: PRL.last_update_date = SYSDATE,
1138: PRL.last_updated_by = FND_GLOBAL.user_id,

Line 1161: UPDATE po_reqexpress_lines_all PRL

1157: --SQL Why: If the supplier is not active after vendor merge,the records
1158: -- associated to that supplier should be moved to point to the
1159: -- new supplier
1160:
1161: UPDATE po_reqexpress_lines_all PRL
1162: SET PRL.suggested_vendor_id = p_to_vendor_id,
1163: last_update_date = SYSDATE,
1164: last_updated_by = FND_GLOBAL.user_id,
1165: last_update_login = FND_GLOBAL.login_id