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.WMS_DIRECT_SHIP_PVT dependencies on WMS_DS_CT_WT_GTEMP

Line 5305: FROM wms_ds_ct_wt_gtemp

5301: ) IS
5302: SELECT 1 FROM dual
5303: WHERE EXISTS
5304: (SELECT 1
5305: FROM wms_ds_ct_wt_gtemp
5306: WHERE org_id = p_organization_id
5307: AND inventory_item_id = p_item_id
5308: AND NVL(inner_lpn_id, lpn_id) = p_lpn_id
5309: AND NVL(lot_number,'#NULL#') = NVL(p_lot_number,'#NULL#')

Line 6169: DEBUG('Calling get_catch_weight as record exists in WMS_DS_CT_WT_GTEMP', 'stage_lpns');

6165: CLOSE c_ds_ct_wt_gtemp_exists;
6166:
6167: IF l_ds_ct_wt_gtemp_exists THEN
6168: IF (l_debug = 1) THEN
6169: DEBUG('Calling get_catch_weight as record exists in WMS_DS_CT_WT_GTEMP', 'stage_lpns');
6170: END IF;
6171: l_shipping_attr(1).picked_quantity2 := GET_CATCH_WEIGHT(
6172: l_shipping_attr(1).ship_from_org_id
6173: , l_shipping_attr(1).transfer_lpn_id

Line 6181: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');

6177: , l_shipping_attr(1).picked_quantity);
6178: ELSE
6179: IF NVL(l_shipping_attr(1).picked_quantity2, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
6180: IF (l_debug = 1) THEN
6181: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');
6182: END IF;
6183: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (
6184: item_id => l_shipping_attr(1).inventory_item_id,
6185: lot_number => l_shipping_attr(1).lot_number,

Line 6573: DEBUG('Calling get_catch_weight as record exists in WMS_DS_CT_WT_GTEMP', 'stage_lpns');

6569: CLOSE c_ds_ct_wt_gtemp_exists;
6570:
6571: IF l_ds_ct_wt_gtemp_exists THEN
6572: IF (l_debug = 1) THEN
6573: DEBUG('Calling get_catch_weight as record exists in WMS_DS_CT_WT_GTEMP', 'stage_lpns');
6574: END IF;
6575: l_shipping_attr(1).picked_quantity2 := GET_CATCH_WEIGHT(
6576: l_shipping_attr(1).ship_from_org_id
6577: , l_shipping_attr(1).transfer_lpn_id

Line 6585: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');

6581: , l_shipping_attr(1).picked_quantity);
6582: ELSE
6583: IF NVL(l_shipping_attr(1).picked_quantity2, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN
6584: IF (l_debug = 1) THEN
6585: DEBUG('Dual UoM items but no entry in WMS_DS_CT_WT_GTEMP so use uom_convert to get picked_quantity2', 'stage_lpns');
6586: END IF;
6587: l_shipping_attr(1).picked_quantity2 := inv_convert.inv_um_convert (
6588: item_id => l_shipping_attr(1).inventory_item_id,
6589: lot_number => l_shipping_attr(1).lot_number,

Line 13890: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t

13886: t.PICKED_QUANTITY, t.PICKED_UOM_CODE, msi.primary_uom_code,
13887: NULL, NULL), 0)) PICKED_QUANTITY_IN_PRI_UOM
13888: ,t.SECONDARY_UOM_CODE
13889: ,t.SECONDARY_QUANTITY
13890: FROM mtl_system_items msi, WMS_DS_CT_WT_GTEMP t
13891: WHERE t.INVENTORY_ITEM_ID = C_INVENTORY_ITEM_ID /* THIS HAS INDEX */
13892: AND t.ORG_ID = C_ORG_ID
13893: AND msi.INVENTORY_ITEM_ID = t.INVENTORY_ITEM_ID
13894: AND msi.ORGANIZATION_ID = t.ORG_ID