APPS.WSH_USA_ACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 2080: FROM mtl_system_items

2076:
2077: -- Bug 3125768: this cursor is introduced to get the inventory transactable flag
2078: CURSOR c_get_pickable(c_item_id NUMBER, c_org_id NUMBER) IS
2079: SELECT NVL(mtl_transactions_enabled_flag, 'N')
2080: FROM mtl_system_items
2081: WHERE inventory_item_id = c_item_id
2082: AND organization_id = c_org_id;
2083:
2084: -- bug#6407943 (begin):Needs to change items org dependent attributes when org changes

Line 2090: FROM mtl_system_items m

2086: c_p_organization_id number)
2087: IS
2088: SELECT hazard_class_id, primary_uom_code, weight_uom_code,
2089: unit_weight, volume_uom_code, unit_volume,description
2090: FROM mtl_system_items m
2091: WHERE m.inventory_item_id = c_p_inventory_item_id
2092: AND m.organization_id = c_p_organization_id;
2093:
2094: l_haz_class_id number;

Line 3142: FROM mtl_system_items m

3138: c_p_organization_id number)
3139: IS
3140: SELECT hazard_class_id, primary_uom_code, weight_uom_code,
3141: unit_weight, volume_uom_code, unit_volume , decode(mtl_transactions_enabled_flag,'Y','Y','N')
3142: FROM mtl_system_items m
3143: WHERE m.inventory_item_id = c_p_inventory_item_id
3144: AND m.organization_id = c_p_organization_id;
3145:
3146: -- Bug 2995052 : Treating the Back Order delivery detail lines also as not released lines.