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_PACKING_WORKBENCH_PVT dependencies on DUAL

Line 2538: FROM dual

2534: IF l_top_model_line_id IS NOT NULL
2535: THEN
2536: BEGIN
2537: SELECT 'Y' INTO l_material_rec.pto_flag
2538: FROM dual
2539: WHERE exists (
2540: select 1 from oe_order_lines_all oel, oe_order_lines_all oel1
2541: where oel.inventory_item_id = l_material_rec.inventory_item_id
2542: and oel.top_model_line_id = l_top_model_line_id

Line 2697: select 1 INTO l_item_in_existing_kit FROM dual

2693:
2694: l_item_in_existing_kit := 0;
2695:
2696: BEGIN
2697: select 1 INTO l_item_in_existing_kit FROM dual
2698: WHERE exists
2699: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG
2700: where WPKG.top_model_line_id = l_kit_rec.top_model_line_id);
2701:

Line 4399: FROM dual;

4395:
4396: IF p_transaction_header_id IS NULL THEN
4397: SELECT mtl_material_transactions_s.NEXTVAL
4398: INTO l_txn_hdr_id
4399: FROM dual;
4400: ELSE
4401: l_txn_hdr_id := p_transaction_header_id;
4402: END IF;
4403: x_transaction_header_id := l_txn_hdr_id;

Line 5898: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists

5894: */
5895:
5896:
5897: BEGIN
5898: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists
5899: (SELECT 1
5900: FROM wms_packing_kitting_gtemp
5901: WHERE component_item_id = p_inventory_item_id
5902: AND ((packed_qty <> order_qty AND packed_qty IS NOT

Line 5965: FROM dual

5961: l_exist NUMBER := 0;
5962: BEGIN
5963: BEGIN
5964: SELECT 1 INTO l_exist
5965: FROM dual
5966: WHERE exists(
5967: SELECT 1 FROM wms_packing_kitting_gtemp
5968: WHERE kit_item_id = p_kit_id
5969: AND component_item_id IS NOT NULL