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 2465: FROM dual

2461: IF l_top_model_line_id IS NOT NULL
2462: THEN
2463: BEGIN
2464: SELECT 'Y' INTO l_material_rec.pto_flag
2465: FROM dual
2466: WHERE exists (
2467: select 1 from oe_order_lines_all oel, oe_order_lines_all oel1
2468: where oel.inventory_item_id = l_material_rec.inventory_item_id
2469: and oel.top_model_line_id = l_top_model_line_id

Line 2624: select 1 INTO l_item_in_existing_kit FROM dual

2620:
2621: l_item_in_existing_kit := 0;
2622:
2623: BEGIN
2624: select 1 INTO l_item_in_existing_kit FROM dual
2625: WHERE exists
2626: (SELECT 1 from WMS_PACKING_KITTING_GTEMP WPKG
2627: where WPKG.top_model_line_id = l_kit_rec.top_model_line_id);
2628:

Line 4233: FROM dual;

4229:
4230: IF p_transaction_header_id IS NULL THEN
4231: SELECT mtl_material_transactions_s.NEXTVAL
4232: INTO l_txn_hdr_id
4233: FROM dual;
4234: ELSE
4235: l_txn_hdr_id := p_transaction_header_id;
4236: END IF;
4237: x_transaction_header_id := l_txn_hdr_id;

Line 5732: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists

5728: */
5729:
5730:
5731: BEGIN
5732: SELECT 1 INTO l_common_qty_filled FROM dual WHERE exists
5733: (SELECT 1
5734: FROM wms_packing_kitting_gtemp
5735: WHERE component_item_id = p_inventory_item_id
5736: AND ((packed_qty <> order_qty AND packed_qty IS NOT

Line 5799: FROM dual

5795: l_exist NUMBER := 0;
5796: BEGIN
5797: BEGIN
5798: SELECT 1 INTO l_exist
5799: FROM dual
5800: WHERE exists(
5801: SELECT 1 FROM wms_packing_kitting_gtemp
5802: WHERE kit_item_id = p_kit_id
5803: AND component_item_id IS NOT NULL