DBA Data[Home] [Help]

APPS.INV_PICK_SLIP_REPORT dependencies on MTL_SYSTEM_ITEMS

Line 301: FROM mtl_system_items

297: END IF;
298: END IF;
299:
300: SELECT decode(serial_number_control_code, 1, 'F', 'T') INTO l_serial_flag
301: FROM mtl_system_items
302: WHERE inventory_item_id = v_mo_line_rec.inventory_item_id
303: AND organization_id = p_org_id;
304:
305: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_header_id FROM DUAL;