APPS.JMF_SHIKYU_ONT_PVT dependencies on PO_HEADERS_ALL

Line 366: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;

362: l_task_id NUMBER;
363:
364: l_project_tbl l_project_Tabtype;
365: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
366: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
367: l_message VARCHAR(2000);
368: l_status_flag BOOLEAN;
369:
370: -- Bug 5216720: Should get Project ID and Task ID from the Replenishment

Line 827: FROM po_headers_all poh

823: /* Log the error in the Concurrent Request log if allocation fails */
824: BEGIN
825: SELECT segment1
826: INTO l_order_number
827: FROM po_headers_all poh
828: WHERE EXISTS
829: (SELECT 1 FROM po_line_locations_all poll
830: WHERE poll.line_location_id = p_subcontract_po_shipment_id
831: AND poll.po_header_id = poh.po_header_id);