DBA Data[Home] [Help]

APPS.INV_ATTRIBUTE_CONTROL_PVT dependencies on MTL_PHYSICAL_ADJUSTMENTS

Line 42: from mtl_physical_adjustments

38: /* Fix for bug 4505262 - Added check on adjustment_quantity in the below query. */
39: if (l_org_count <> 1) then
40: select count(1)
41: into l_org_count
42: from mtl_physical_adjustments
43: where inventory_item_id = p_item_id
44: and organization_id = p_org_id
45: and approval_status = 1
46: and adjustment_quantity <> 0

Line 72: from mtl_physical_adjustments

68: /* Fix for bug 4505262 - Added check on adjustment_quantity in the below query. */
69: if (l_master_count <> 1) then
70: select count(1)
71: into l_master_count
72: from mtl_physical_adjustments
73: where inventory_item_id = p_item_id
74: and (organization_id in
75: (select organization_id
76: from mtl_parameters