APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on MTL_UNITS_OF_MEASURE

Line 1338: -- and also to validate with mtl_units_of_measure

1334: -- GL Account valid organization List
1335: l_valid_org_tbl INV_OrgHierarchy_PVT.OrgID_tbl_type;
1336:
1337: -- Cursor to retrieve primary unit of measure for the item
1338: -- and also to validate with mtl_units_of_measure
1339: CURSOR primary_uom_cur(c_master_org_id NUMBER
1340: ,c_inventory_item_id NUMBER
1341: )
1342: IS

Line 1348: , mtl_units_of_measure muom

1344: msib.primary_uom_code primary_uom_code
1345: , msib.primary_unit_of_measure primary_unit_of_measure
1346: FROM
1347: mtl_system_items_b msib
1348: , mtl_units_of_measure muom
1349: WHERE msib.organization_id = c_master_org_id
1350: AND msib.inventory_item_id = c_inventory_item_id
1351: AND msib.primary_unit_of_measure = muom.unit_of_measure
1352: AND SYSDATE < nvl(muom.disable_date,SYSDATE+1);

Line 1709: -- validate with mtl_units_of_measure

1705: EXIT WHEN l_item_cur%NOTFOUND;
1706:
1707: -- ===========================================
1708: -- Get Primary Unit of Measure of the item
1709: -- validate with mtl_units_of_measure
1710: -- ===========================================
1711: OPEN primary_uom_cur(l_master_org_id
1712: ,l_inventory_item_id
1713: );