APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_REQUISITION_LINES_ALL

Line 3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom

3223: , quantity
3224: , project_id
3225: , task_id
3226: , source_type_code
3227: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom
3228: where prh.requisition_header_id = p_header_id
3229: and prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
3230: and prd.requisition_line_id = prl.requisition_line_id
3231: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'

Line 3358: FROM po_requisition_lines_all --

3354: -- to delete the reservation on the req (remove req supply)
3355: --
3356: CURSOR get_req_hdr_lines (v_po_req_header_id IN NUMBER) IS
3357: SELECT requisition_line_id, source_type_code
3358: FROM po_requisition_lines_all --
3359: WHERE requisition_header_id = v_po_req_header_id;
3360:
3361: --
3362: --get the PO header for the po line id that is cancelled

Line 3545: , po_requisition_lines_all d

3541: , d.requisition_header_id
3542: FROM rcv_transactions a
3543: , rcv_shipment_lines b
3544: , po_req_distributions_all c
3545: , po_requisition_lines_all d
3546: , mtl_units_of_measure e
3547: WHERE a.transaction_id = v_transaction_id
3548: AND a.source_document_code = 'REQ'
3549: AND b.shipment_line_id = a.shipment_line_id

Line 5566: po_requisition_lines_all WHERE requisition_line_id = p_line_id;

5562: END IF;
5563:
5564: BEGIN
5565: SELECT source_type_code INTO l_source_type_code FROM
5566: po_requisition_lines_all WHERE requisition_line_id = p_line_id;
5567:
5568: EXCEPTION
5569: WHEN no_data_found THEN
5570: IF g_debug= C_Debug_Enabled THEN

Line 6026: po_requisition_lines_all WHERE requisition_line_id = p_line_id;

6022: SELECT destination_organization_id, item_id, unit_meas_lookup_code, quantity INTO
6023: l_organization_id,
6024: l_inventory_item_id,
6025: l_req_unit_meas, l_req_qty FROM
6026: po_requisition_lines_all WHERE requisition_line_id = p_line_id;
6027: EXCEPTION
6028: WHEN no_data_found THEN
6029: IF g_debug= C_Debug_Enabled THEN
6030: mydebug ('No records found for req line id. req line:'|| p_line_id ,c_api_name,9);