DBA Data[Home] [Help]

APPS.MTL_OG_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 168: FROM mtl_system_items

164:
165: /* Checking whether Parent Item is Serial Controlled */
166: BEGIN
167: SELECT serial_number_control_code INTO l_parent_ser_ctrl
168: FROM mtl_system_items
169: WHERE inventory_item_id = p_parent_item_id
170: AND organization_id = p_org_id;
171:
172: IF l_parent_ser_ctrl IN (1,6) THEN