APPS.INV_CYC_LOVS dependencies on MTL_CYCLE_COUNT_ITEMS

Line 1713: FROM mtl_cycle_count_items

1709:
1710: BEGIN
1711: SELECT abc_class_id
1712: INTO l_abc_class_id
1713: FROM mtl_cycle_count_items
1714: WHERE cycle_count_header_id = l_cycle_count_header_id
1715: AND inventory_item_id = l_inventory_item_id;
1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN

Line 1727: FROM mtl_cycle_count_items

1723: SELECT approval_tolerance_positive,
1724: approval_tolerance_negative
1725: INTO l_item_app_tol_pos,
1726: l_item_app_tol_neg
1727: FROM mtl_cycle_count_items
1728: WHERE cycle_count_header_id = l_cycle_count_header_id
1729: AND inventory_item_id = l_inventory_item_id;
1730: ELSE
1731: l_item_app_tol_pos := NULL;

Line 7510: FROM mtl_cycle_count_items

7506: -- Make sure that this inventory item is defined in the
7507: -- cycle count header item scope
7508: SELECT COUNT ( * )
7509: INTO l_temp_count
7510: FROM mtl_cycle_count_items
7511: WHERE inventory_item_id = v_lpn_id.inventory_item_id
7512: AND cycle_count_header_id = p_cycle_count_header_id;
7513:
7514: IF ( l_temp_count <> 0 ) THEN

Line 7552: FROM mtl_cycle_count_items

7548: -- Make sure that this inventory item is defined in the
7549: -- cycle count header item scope
7550: SELECT COUNT ( * )
7551: INTO l_temp_count
7552: FROM mtl_cycle_count_items
7553: WHERE inventory_item_id = v_lpn_content.inventory_item_id
7554: AND cycle_count_header_id = p_cycle_count_header_id;
7555:
7556: IF ( l_temp_count <> 0 ) THEN

Line 7604: FROM mtl_cycle_count_items

7600: -- Make sure that this inventory item is defined in the
7601: -- cycle count header item scope
7602: SELECT COUNT ( * )
7603: INTO l_temp_count
7604: FROM mtl_cycle_count_items
7605: WHERE inventory_item_id =
7606: v_lpn_serial_content.inventory_item_id
7607: AND cycle_count_header_id = p_cycle_count_header_id;
7608:

Line 7677: FROM mtl_cycle_count_items

7673: -- Make sure that this inventory item is defined in the
7674: -- cycle count header item scope
7675: SELECT COUNT ( * )
7676: INTO l_temp_count
7677: FROM mtl_cycle_count_items
7678: WHERE inventory_item_id =
7679: v_lpn_multiple_serial.inventory_item_id
7680: AND cycle_count_header_id = p_cycle_count_header_id;
7681: