APPS.INV_MAINTAIN_RESERVATION_PUB dependencies on PO_REQUISITION_LINES_ALL

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

3213: , project_id
3214: , task_id
3215: , source_type_code
3216: , unit_of_measure -- Bug 8524455
3217: from po_requisition_lines_all prl, po_requisition_headers_all prh , po_req_distributions_all prd, mtl_units_of_measure muom
3218: where prh.requisition_header_id = p_header_id
3219: and prh.REQUISITION_HEADER_ID = prl.REQUISITION_HEADER_ID
3220: and prd.requisition_line_id = prl.requisition_line_id
3221: and nvl(prl.modified_by_agent_flag,'N') <> 'Y'

Line 3359: FROM po_requisition_lines_all --

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

Line 3556: , po_requisition_lines_all d

3552: , d.requisition_header_id
3553: FROM rcv_transactions a
3554: , rcv_shipment_lines b
3555: , po_req_distributions_all c
3556: , po_requisition_lines_all d
3557: , mtl_units_of_measure e
3558: WHERE a.transaction_id = v_transaction_id
3559: AND a.source_document_code = 'REQ'
3560: AND b.shipment_line_id = a.shipment_line_id

Line 5816: po_requisition_lines_all WHERE requisition_line_id = p_line_id;

5812: END IF;
5813:
5814: BEGIN
5815: SELECT source_type_code INTO l_source_type_code FROM
5816: po_requisition_lines_all WHERE requisition_line_id = p_line_id;
5817:
5818: EXCEPTION
5819: WHEN no_data_found THEN
5820: IF g_debug= C_Debug_Enabled THEN

Line 6274: po_requisition_lines_all WHERE requisition_line_id = p_line_id;

6270: SELECT destination_organization_id, item_id, unit_meas_lookup_code, quantity INTO
6271: l_organization_id,
6272: l_inventory_item_id,
6273: l_req_unit_meas, l_req_qty FROM
6274: po_requisition_lines_all WHERE requisition_line_id = p_line_id;
6275: EXCEPTION
6276: WHEN no_data_found THEN
6277: IF g_debug= C_Debug_Enabled THEN
6278: mydebug ('No records found for req line id. req line:'|| p_line_id ,c_api_name,9);