eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.WSH_CONTAINER_ACTIONS dependencies on MTL_SYSTEM_ITEMS

Line 88: mtl_max_load MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE,

84:
85: -- valid_flag indicates if this container can be used for packing or not
86: -- inactive containers cannot be used
87: TYPE cont_msi_info IS RECORD (
88: mtl_max_load MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE,
89: mtl_max_vol MTL_SYSTEM_ITEMS.internal_volume%TYPE,
90: mtl_wt_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE,
91: mtl_vol_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE,
92: valid_flag VARCHAR2(1)

Line 89: mtl_max_vol MTL_SYSTEM_ITEMS.internal_volume%TYPE,

85: -- valid_flag indicates if this container can be used for packing or not
86: -- inactive containers cannot be used
87: TYPE cont_msi_info IS RECORD (
88: mtl_max_load MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE,
89: mtl_max_vol MTL_SYSTEM_ITEMS.internal_volume%TYPE,
90: mtl_wt_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE,
91: mtl_vol_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE,
92: valid_flag VARCHAR2(1)
93: );

Line 90: mtl_wt_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE,

86: -- inactive containers cannot be used
87: TYPE cont_msi_info IS RECORD (
88: mtl_max_load MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE,
89: mtl_max_vol MTL_SYSTEM_ITEMS.internal_volume%TYPE,
90: mtl_wt_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE,
91: mtl_vol_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE,
92: valid_flag VARCHAR2(1)
93: );
94: TYPE cont_msi_tab IS TABLE OF cont_msi_info INDEX BY BINARY_INTEGER;

Line 91: mtl_vol_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE,

87: TYPE cont_msi_info IS RECORD (
88: mtl_max_load MTL_SYSTEM_ITEMS.maximum_load_weight%TYPE,
89: mtl_max_vol MTL_SYSTEM_ITEMS.internal_volume%TYPE,
90: mtl_wt_uom MTL_SYSTEM_ITEMS.weight_uom_code%TYPE,
91: mtl_vol_uom MTL_SYSTEM_ITEMS.volume_uom_code%TYPE,
92: valid_flag VARCHAR2(1)
93: );
94: TYPE cont_msi_tab IS TABLE OF cont_msi_info INDEX BY BINARY_INTEGER;
95: g_cont_msi_tab cont_msi_tab;

Line 152: FROM MTL_SYSTEM_ITEMS

148: x_return_status OUT NOCOPY VARCHAR2)
149: IS
150: CURSOR l_valid_cont_csr (p_cont_item_id NUMBER, p_org_id NUMBER) IS
151: SELECT 'X'
152: FROM MTL_SYSTEM_ITEMS
153: WHERE inventory_item_id = p_cont_item_id
154: AND container_item_flag = 'Y'
155: AND organization_id = p_org_id
156: AND nvl(vehicle_item_flag,'N') = 'N'

Line 250: FROM MTL_SYSTEM_ITEMS

246: SELECT Description, Container_Type_Code, weight_uom_code, volume_uom_code,
247: minimum_fill_percent, maximum_load_weight, internal_volume, primary_uom_code,
248: -- J: W/V Changes
249: unit_weight, unit_volume
250: FROM MTL_SYSTEM_ITEMS
251: WHERE inventory_item_id = v_cont_item_id
252: AND container_item_flag = 'Y'
253: AND organization_id = v_org_id
254: AND nvl(vehicle_item_flag,'N') = 'N'

Line 716: FROM MTL_SYSTEM_ITEMS

712: SELECT Description, Container_Type_Code, weight_uom_code, volume_uom_code,
713: minimum_fill_percent, maximum_load_weight, internal_volume, primary_uom_code,
714: -- J: W/V Changes
715: unit_weight, unit_volume
716: FROM MTL_SYSTEM_ITEMS
717: WHERE inventory_item_id = v_cont_item_id
718: AND container_item_flag = 'Y'
719: AND organization_id = v_org_id
720: AND nvl(vehicle_item_flag,'N') = 'N'

Line 4438: FROM MTL_SYSTEM_ITEMS

4434: -- in this cursor we can add filters as required in 2428050
4435: CURSOR Get_Cont_Msi (v_cont_item_id NUMBER, v_org_id NUMBER) IS
4436: SELECT maximum_load_weight, internal_volume,
4437: weight_uom_code, volume_uom_code
4438: FROM MTL_SYSTEM_ITEMS
4439: WHERE inventory_item_id = v_cont_item_id
4440: AND organization_id = v_org_id
4441: -- bug 2828591 - remove the condition since it will prevent user to create container with other status
4442: -- AND inventory_item_status_code = 'Active'

Line 5599: MTL_SYSTEM_ITEMS msi,

5595: wda.delivery_id delivery_id, -- added delivery id
5596: msi.indivisible_flag indivisible_flag
5597: FROM WSH_DELIVERY_DETAILS wdd,
5598: wsh_delivery_assignments_v wda,
5599: MTL_SYSTEM_ITEMS msi,
5600: WSH_TMP wt
5601: WHERE wdd.delivery_detail_id = wt.id
5602: AND wdd.delivery_detail_id = wda.delivery_detail_id
5603: AND wdd.container_flag = 'N'

Line 5652: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

5648: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_DD_FOR_PACK';
5649: --
5650:
5651: -- HW OPMCONV - New variable to hold item info
5652: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
5653: -- HW OPM BUG# 3011758
5654: -- HW OPMCONV - Removed opm variables
5655:
5656: -- HW OPMCONV - Renamed variable from lot_indivisible to l_lot_divisible_flag

Line 5787: , x_mtl_system_items_rec => l_item_info

5783: WSH_DELIVERY_DETAILS_INV.Get_item_information
5784: (
5785: p_organization_id => rec.organization_id
5786: , p_inventory_item_id => rec.inventory_item_id
5787: , x_mtl_system_items_rec => l_item_info
5788: , x_return_status => l_return_status
5789: );
5790:
5791:

Line 8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8529:
8530: -- HW OPMCONV - Renamed variable to l_lot_divisible_flag
8531: l_lot_divisible_flag VARCHAR2(1);
8532: -- HW OPMCONV - New variable to hold item info
8533: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8534:
8535: -- LPN CONV. rv
8536: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8537: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 8849: , x_mtl_system_items_rec => l_item_info

8845: WSH_DELIVERY_DETAILS_INV.Get_item_information
8846: (
8847: p_organization_id =>l_det_org_id
8848: , p_inventory_item_id => l_det_inv_item_id
8849: , x_mtl_system_items_rec => l_item_info
8850: , x_return_status => l_return_status
8851: );
8852:
8853: wsh_util_core.api_post_call

Line 9340: , x_mtl_system_items_rec => l_item_info

9336: WSH_DELIVERY_DETAILS_INV.Get_item_information
9337: (
9338: p_organization_id => l_det_org_id
9339: , p_inventory_item_id => l_det_inv_item_id
9340: , x_mtl_system_items_rec => l_item_info
9341: , x_return_status => l_return_status
9342: );
9343:
9344: wsh_util_core.api_post_call

Line 13443: FROM MTL_SYSTEM_ITEMS

13439: /*CURSOR Get_Cont_Item_Info (v_cont_item_id NUMBER, v_org_id NUMBER) IS
13440: SELECT Container_Type_Code, weight_uom_code, volume_uom_code,
13441: minimum_fill_percent, maximum_load_weight, internal_volume, primary_uom_code,
13442: unit_weight, unit_volume
13443: FROM MTL_SYSTEM_ITEMS
13444: WHERE inventory_item_id = v_cont_item_id
13445: AND container_item_flag = 'Y'
13446: AND organization_id = v_org_id
13447: AND nvl(vehicle_item_flag,'N') = 'N'