APPS.MTL_INV_UTIL_GRP dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 1550: FROM MTL_CYCLE_COUNT_ENTRIES

1546: RETURN BOOLEAN IS
1547:
1548: CURSOR cce_csr IS
1549: SELECT inventory_item_id
1550: FROM MTL_CYCLE_COUNT_ENTRIES
1551: WHERE organization_id = p_organization_id
1552: AND parent_lpn_id = p_parent_lpn_id
1553: AND inventory_item_id = p_inventory_item_id
1554: AND NVL(lot_number, '@') = NVL(p_lot_number, '@')

Line 1560: l_dummy MTL_CYCLE_COUNT_ENTRIES.inventory_item_id%TYPE;

1556: AND NVL(serial_number, '@') = NVL(p_serial_number, '@')
1557: AND NVL(cost_group_id, -1) = NVL(p_cost_group_id, -1)
1558: AND entry_status_code IN (1, 3);
1559:
1560: l_dummy MTL_CYCLE_COUNT_ENTRIES.inventory_item_id%TYPE;
1561:
1562: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1563: BEGIN
1564: OPEN cce_csr;