APPS.MTL_CCEOI_CONC_PVT dependencies on MTL_CYCLE_COUNT_HEADERS

Line 98: FROM mtl_cycle_count_headers

94: DECLARE
95: --
96: CURSOR L_CC_Header_Records_Csr (cchid number )IS
97: SELECT *
98: FROM mtl_cycle_count_headers
99: WHERE
100: (cycle_count_header_id = cchid);
101: --
102: CURSOR L_CycleCount_Records_Csr(HID NUMBER, CCID IN NUMBER) IS

Line 234: from mtl_cycle_count_headers

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
235: where cycle_count_header_id = c_rec.Cycle_Count_Header_id;
236: if c_rec.parent_lpn_id is not null then
237: if c_rec.inventory_item_id is not null then
238: MTL_INV_UTIL_GRP.Get_LPN_Item_SysQty