APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 47: from mtl_cycle_count_entries

43: begin
44: -- check at org level
45: select count(1)
46: into l_org_count
47: from mtl_cycle_count_entries
48: where inventory_item_id = p_item_id and
49: organization_id = p_org_id and
50: /*Change for bug 8208397*/ /*Check should be for status 1-Uncounted/2-Pending Approval/3-Recount*/
51: /*entry_status_code = 2 and*/

Line 83: from mtl_cycle_count_entries

79: where organization_id = p_org_id;
80:
81: select count(1)
82: into l_master_count
83: from mtl_cycle_count_entries
84: where inventory_item_id = p_item_id and
85: (organization_id in
86: (select organization_id
87: from mtl_parameters