APPS.WSH_USA_ACTIONS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1786: FROM mtl_system_items

1782:
1783: -- Bug 3125768: this cursor is introduced to get the inventory transactable flag
1784: CURSOR c_get_pickable(c_item_id NUMBER, c_org_id NUMBER) IS
1785: SELECT NVL(mtl_transactions_enabled_flag, 'N')
1786: FROM mtl_system_items
1787: WHERE inventory_item_id = c_item_id
1788: AND organization_id = c_org_id;
1789:
1790: -- bug#6407943 (begin):Needs to change items org dependent attributes when org changes

Line 1796: FROM mtl_system_items m

1792: c_p_organization_id number)
1793: IS
1794: SELECT hazard_class_id, primary_uom_code, weight_uom_code,
1795: unit_weight, volume_uom_code, unit_volume,description
1796: FROM mtl_system_items m
1797: WHERE m.inventory_item_id = c_p_inventory_item_id
1798: AND m.organization_id = c_p_organization_id;
1799:
1800: l_haz_class_id number;

Line 2830: FROM mtl_system_items m

2826: c_p_organization_id number)
2827: IS
2828: SELECT hazard_class_id, primary_uom_code, weight_uom_code,
2829: unit_weight, volume_uom_code, unit_volume , decode(mtl_transactions_enabled_flag,'Y','Y','N')
2830: FROM mtl_system_items m
2831: WHERE m.inventory_item_id = c_p_inventory_item_id
2832: AND m.organization_id = c_p_organization_id;
2833:
2834: -- Bug 2995052 : Treating the Back Order delivery detail lines also as not released lines.