APPS.PO_AP_MERGE_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 449: FROM po_requisition_lines_all RL,

445: INTO l_pass_val
446: FROM dual
447: WHERE EXISTS (
448: SELECT NULL
449: FROM po_requisition_lines_all RL,
450: po_headers GA
451: WHERE RL.vendor_id = p_from_vendor_id
452: AND RL.vendor_site_id = p_from_site_id
453: AND RL.blanket_po_header_id = GA.po_header_id

Line 488: FROM po_requisition_lines_all RL,

484: INTO l_pass_val
485: FROM dual
486: WHERE EXISTS (
487: SELECT NULL
488: FROM po_requisition_lines_all RL,
489: po_headers GA
490: WHERE GA.vendor_id = p_from_vendor_id
491: AND GA.vendor_site_id = p_from_site_id
492: AND GA.global_agreement_flag = 'Y'

Line 958: --Modifies: po_requisition_lines_all

954: -----------------------------------------------------------------------
955: --Start of Comments
956: --Name: update_req_line_vdr_info
957: --Pre-reqs:
958: --Modifies: po_requisition_lines_all
959: --Locks:
960: -- None
961: --Function:
962: -- Update requisition lines in all OU with the new supplier information

Line 1002: -- modify PO_REQUISITION_LINES_ALL to use new vendor in all OUs

998: END IF;
999:
1000: l_progress := '000';
1001:
1002: -- modify PO_REQUISITION_LINES_ALL to use new vendor in all OUs
1003:
1004: --SQL What: Update suggested vendor information to reflect vendor merge
1005: -- on req in all OU
1006: --SQL Why: Vendor Merge functionality

Line 1008: UPDATE po_requisition_lines_all

1004: --SQL What: Update suggested vendor information to reflect vendor merge
1005: -- on req in all OU
1006: --SQL Why: Vendor Merge functionality
1007:
1008: UPDATE po_requisition_lines_all
1009: SET suggested_vendor_name =
1010: (SELECT PV.vendor_name
1011: FROM po_vendors PV
1012: WHERE PV.vendor_id = p_to_vendor_id),

Line 1040: UPDATE po_requisition_lines_all

1036: -- for reqs in all OUs, if the req does not have vendor site
1037: -- info, and the supplier becomes inactive due to vendor merge
1038: --SQL Why: Vendor Merge functionality
1039:
1040: UPDATE po_requisition_lines_all
1041: SET suggested_vendor_name =
1042: (SELECT PV.vendor_name
1043: FROM po_vendors PV
1044: WHERE PV.vendor_id = p_to_vendor_id),