APPS.MTL_INV_VALIDATE_GRP dependencies on MTL_CYCLE_COUNT_ITEMS

Line 1928: -- mtl_cycle_count_items.

1924: -- information to package variables.
1925: -- The id takes presedence over the concatenated segment, which
1926: -- takes presedence over the individual segments. IS the item present
1927: -- IN the TABLE mtl_system_items, it will be checked IF it IS present IN TABLE
1928: -- mtl_cycle_count_items.
1929: -- Parameters:
1930: -- IN :
1931: -- p_api_version IN NUMBER (required)
1932: -- API Version of this procedure

Line 1975: FROM MTL_CYCLE_COUNT_ITEMS

1971: --
1972: CURSOR L_CCItemsID_Crs(id IN VARCHAR2, cchead IN NUMBER) IS
1973: SELECT
1974: inventory_item_id
1975: FROM MTL_CYCLE_COUNT_ITEMS
1976: WHERE
1977: inventory_item_id = id
1978: AND cycle_count_header_id = cchead;
1979: --

Line 2082: -- check IF the item IS present IN mtl_cycle_count_items

2078: ELSIF
2079: l_counter = 1 THEN
2080: L_counter := 0;
2081: --
2082: -- check IF the item IS present IN mtl_cycle_count_items
2083: if p_cycle_count_header_id is not null then
2084: FOR c_rec IN L_CCItemsID_Crs(MTL_CCEOI_VAR_PVT.G_inventory_item_id,
2085: p_cycle_count_header_id) LOOP
2086: --