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 695: FROM mtl_system_items_b

691: AND poll.po_header_id = poh.po_header_id);
692:
693: SELECT segment1
694: INTO l_sub_comp
695: FROM mtl_system_items_b
696: WHERE inventory_item_id = l_item_id
697: AND organization_id = l_subcontract_orders_rec.tp_organization_id;
698:
699: fnd_message.set_name('JMF','JMF_SHK_REP_PO_ERROR');