DBA Data[Home] [Help]

APPS.INV_MWB_CYCLE_COUNT dependencies on MTL_CYCLE_COUNT_ITEMS

Line 41: from mtl_cycle_count_items

37: SAVEPOINT MWB_CREATE_CC;
38:
39: select count(*)
40: into l_cc_items_ct
41: from mtl_cycle_count_items
42: where inventory_item_id = p_inventory_item_id
43: and cycle_count_header_id = p_cycle_count_header_id
44: and abc_class_id = p_abc_class_id;
45:

Line 76: MTL_CYCLE_COUNT_ITEMS_PKG.Insert_Row(

72: );
73: END IF;
74:
75: IF l_cc_items_ct = 0 then
76: MTL_CYCLE_COUNT_ITEMS_PKG.Insert_Row(
77: X_Rowid => l_RowId2,
78: X_Cycle_Count_Header_Id => p_cycle_count_header_id,
79: X_Inventory_Item_Id => p_Inventory_Item_Id,
80: X_Last_Update_Date => l_last_update_date,