DBA Data[Home] [Help]

APPS.INV_MO_CANCEL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1260: FROM mtl_system_items

1256: FOR UPDATE;
1257:
1258: CURSOR c_primary_uom IS
1259: SELECT primary_uom_code
1260: FROM mtl_system_items
1261: WHERE organization_id = l_organization_id
1262: AND inventory_item_id = l_inventory_item_id;
1263:
1264: /*Bug#5095840. Added the below cursor to fetch the source line id

Line 2268: FROM mtl_system_items

2264: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N'); --Bug 7190635
2265:
2266: CURSOR c_primary_uom IS
2267: SELECT primary_uom_code
2268: FROM mtl_system_items
2269: WHERE organization_id = l_organization_id
2270: AND inventory_item_id = l_inventory_item_id;
2271:
2272: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);