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: --Bugfix 9767052: Adding this variable for debugging purposes.

Line 969: FROM po_headers_all poh

965: lStmtNo := 140;
966:
967: SELECT segment1
968: INTO l_order_number
969: FROM po_headers_all poh
970: WHERE EXISTS
971: (SELECT 1 FROM po_line_locations_all poll
972: WHERE poll.line_location_id = p_subcontract_po_shipment_id
973: AND poll.po_header_id = poh.po_header_id);