DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 60: from mtl_physical_adjustments

56: if (l_org_count <> 1) then
57: IF(G_ITEM_ID <> p_item_id OR G_ORG_ID <> p_org_id) THEN -- Bug 12393250
58: select count(1)
59: into l_org_count
60: from mtl_physical_adjustments
61: where inventory_item_id = p_item_id
62: and organization_id = p_org_id
63: and approval_status = 1
64: and adjustment_quantity <> 0

Line 101: from mtl_physical_adjustments

97: if (l_master_count <> 1) then
98: IF(G_ITEM_ID_1 <> p_item_id or G_ORG_ID_1 <> p_org_id) THEN -- Bug 12393250
99: select count(1)
100: into l_master_count
101: from mtl_physical_adjustments
102: where inventory_item_id = p_item_id
103: and (organization_id in
104: (select organization_id
105: from mtl_parameters