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.

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 689: FROM MTL_SYSTEM_ITEMS

685: SELECT Description, Container_Type_Code, weight_uom_code, volume_uom_code,
686: minimum_fill_percent, maximum_load_weight, internal_volume, primary_uom_code,
687: -- J: W/V Changes
688: unit_weight, unit_volume
689: FROM MTL_SYSTEM_ITEMS
690: WHERE inventory_item_id = v_cont_item_id
691: AND container_item_flag = 'Y'
692: AND organization_id = v_org_id
693: AND nvl(vehicle_item_flag,'N') = 'N'

Line 4366: FROM MTL_SYSTEM_ITEMS

4362: -- in this cursor we can add filters as required in 2428050
4363: CURSOR Get_Cont_Msi (v_cont_item_id NUMBER, v_org_id NUMBER) IS
4364: SELECT maximum_load_weight, internal_volume,
4365: weight_uom_code, volume_uom_code
4366: FROM MTL_SYSTEM_ITEMS
4367: WHERE inventory_item_id = v_cont_item_id
4368: AND organization_id = v_org_id
4369: -- bug 2828591 - remove the condition since it will prevent user to create container with other status
4370: -- AND inventory_item_status_code = 'Active'

Line 5527: MTL_SYSTEM_ITEMS msi,

5523: wda.delivery_id delivery_id, -- added delivery id
5524: msi.indivisible_flag indivisible_flag
5525: FROM WSH_DELIVERY_DETAILS wdd,
5526: wsh_delivery_assignments_v wda,
5527: MTL_SYSTEM_ITEMS msi,
5528: WSH_TMP wt
5529: WHERE wdd.delivery_detail_id = wt.id
5530: AND wdd.delivery_detail_id = wda.delivery_detail_id
5531: AND wdd.container_flag = 'N'

Line 5580: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

5576: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_DD_FOR_PACK';
5577: --
5578:
5579: -- HW OPMCONV - New variable to hold item info
5580: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
5581: -- HW OPM BUG# 3011758
5582: -- HW OPMCONV - Removed opm variables
5583:
5584: -- HW OPMCONV - Renamed variable from lot_indivisible to l_lot_divisible_flag

Line 5715: , x_mtl_system_items_rec => l_item_info

5711: WSH_DELIVERY_DETAILS_INV.Get_item_information
5712: (
5713: p_organization_id => rec.organization_id
5714: , p_inventory_item_id => rec.inventory_item_id
5715: , x_mtl_system_items_rec => l_item_info
5716: , x_return_status => l_return_status
5717: );
5718:
5719:

Line 8404: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8400:
8401: -- HW OPMCONV - Renamed variable to l_lot_divisible_flag
8402: l_lot_divisible_flag VARCHAR2(1);
8403: -- HW OPMCONV - New variable to hold item info
8404: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8405:
8406: -- LPN CONV. rv
8407: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
8408: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

Line 8720: , x_mtl_system_items_rec => l_item_info

8716: WSH_DELIVERY_DETAILS_INV.Get_item_information
8717: (
8718: p_organization_id =>l_det_org_id
8719: , p_inventory_item_id => l_det_inv_item_id
8720: , x_mtl_system_items_rec => l_item_info
8721: , x_return_status => l_return_status
8722: );
8723:
8724: wsh_util_core.api_post_call

Line 9211: , x_mtl_system_items_rec => l_item_info

9207: WSH_DELIVERY_DETAILS_INV.Get_item_information
9208: (
9209: p_organization_id => l_det_org_id
9210: , p_inventory_item_id => l_det_inv_item_id
9211: , x_mtl_system_items_rec => l_item_info
9212: , x_return_status => l_return_status
9213: );
9214:
9215: wsh_util_core.api_post_call

Line 13293: FROM MTL_SYSTEM_ITEMS

13289: /*CURSOR Get_Cont_Item_Info (v_cont_item_id NUMBER, v_org_id NUMBER) IS
13290: SELECT Container_Type_Code, weight_uom_code, volume_uom_code,
13291: minimum_fill_percent, maximum_load_weight, internal_volume, primary_uom_code,
13292: unit_weight, unit_volume
13293: FROM MTL_SYSTEM_ITEMS
13294: WHERE inventory_item_id = v_cont_item_id
13295: AND container_item_flag = 'Y'
13296: AND organization_id = v_org_id
13297: AND nvl(vehicle_item_flag,'N') = 'N'