APPS.JMF_SHIKYU_PO_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 164: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

160: l_ship_to_location_id NUMBER;
161: l_max_wait NUMBER;
162: l_batch_id NUMBER;
163: l_max_line_location_id NUMBER;
164: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
165: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
166: l_status_flag BOOLEAN;
167:
168: CURSOR c_rec IS

Line 790: FROM mtl_system_items_b

786: AND poll.po_header_id = poh.po_header_id);
787:
788: SELECT segment1
789: INTO l_sub_comp
790: FROM mtl_system_items_b
791: WHERE inventory_item_id = l_item_id
792: AND organization_id = l_subcontract_orders_rec.tp_organization_id;
793:
794: fnd_message.set_name('JMF','JMF_SHK_REP_PO_ERROR');