DBA Data[Home] [Help]

APPS.MTL_CCEOI_CONC_PVT dependencies on MTL_SYSTEM_ITEMS

Line 123: FROM mtl_system_items msi, mtl_parameters mtp

119: , msi.secondary_default_ind
120: , msi.secondary_uom_code
121: , msi.process_costing_enabled_flag
122: , mtp.process_enabled_flag
123: FROM mtl_system_items msi, mtl_parameters mtp
124: WHERE mtp.organization_id = cp_organization_id
125: AND msi.organization_id = mtp.organization_id
126: AND msi.inventory_item_id = cp_inventory_item_id;
127: -- END INVCONV

Line 230: from mtl_system_items

226:
227: -- This code is added for the bug 2311404 by aapaul
228: if (c_rec.system_quantity_current is null) then
229: select SERIAL_NUMBER_CONTROL_CODE into x_serial_number_control
230: from mtl_system_items
231: where organization_id = c_rec.organization_id
232: and inventory_item_id = c_rec.inventory_item_id;
233: select SERIAL_COUNT_OPTION into x_serial_count_option
234: from mtl_cycle_count_headers