APPS.WMS_TASK_UTILS_PVT dependencies on DUAL

Line 650: FROM DUAL

646:
647: BEGIN
648: SELECT 'E'
649: INTO l_processed
650: FROM DUAL
651: WHERE EXISTS(SELECT 1
652: FROM mtl_material_transactions_temp
653: WHERE transaction_header_id = p_header_id
654: AND process_flag = 'E');

Line 675: FROM DUAL

671: END IF;
672:
673: SELECT 'Y'
674: INTO l_processed
675: FROM DUAL
676: WHERE EXISTS(SELECT transaction_set_id
677: FROM mtl_material_transactions
678: WHERE transaction_set_id = p_header_id);
679:

Line 1525: FROM DUAL

1521:
1522: BEGIN
1523: SELECT 'Y'
1524: INTO l_crossdocked
1525: FROM DUAL
1526: WHERE EXISTS(
1527: SELECT mtrl.line_id
1528: FROM mtl_txn_request_lines mtrl, mtl_material_transactions mmt
1529: WHERE mtrl.line_id = mmt.move_order_line_id

Line 1572: FROM DUAL;

1568: END IF;
1569:
1570: SELECT mtl_material_transactions_s.NEXTVAL
1571: INTO new_txn_header_id
1572: FROM DUAL;
1573:
1574: IF (l_debug = 1) THEN
1575: mydebug('New Txn Hdr id is ' || new_txn_header_id);
1576: END IF;

Line 1635: FROM DUAL;

1631: END IF;
1632:
1633: SELECT mtl_material_transactions_s.NEXTVAL
1634: INTO new_txn_temp_id
1635: FROM DUAL;
1636:
1637: IF (l_debug = 1) THEN
1638: mydebug('New Txn Temp id is ' || new_txn_temp_id);
1639: END IF;

Line 1962: SELECT 'Y' INTO l_already_used FROM dual WHERE exists

1958:
1959: /**2706001 checking group mark ids here **/
1960: l_already_used := 'N';
1961: BEGIN
1962: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
1963: (SELECT 1
1964: FROM mtl_serial_numbers
1965: WHERE
1966: --Bug 2940878 fix added current_organization_id ,

Line 2065: FROM dual;

2061:
2062: /**2706001 moved this out of below loop **/
2063: SELECT mtl_material_transactions_s.NEXTVAL
2064: INTO ser_transaction_temp_id
2065: FROM dual;
2066:
2067: /**2706001 was using cnt6 earlier **/
2068: FOR cnt6 IN 1 .. msnt_table.COUNT LOOP
2069: ser_row := msnt_table(cnt6);

Line 2075: SELECT 'Y' INTO l_already_used FROM dual WHERE exists

2071: IF ser_row.transaction_temp_id = lot_row.serial_transaction_temp_id THEN
2072: /**2706001 checking group mark ids here **/
2073: l_already_used := 'N';
2074: BEGIN
2075: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
2076: (SELECT 1
2077: FROM mtl_serial_numbers
2078: WHERE
2079: --Bug 2940878 fix added current_organization_id ,

Line 2481: FROM DUAL

2477:
2478: BEGIN
2479: SELECT 'Y'
2480: INTO l_multiple_rows
2481: FROM DUAL
2482: WHERE EXISTS(SELECT transaction_temp_id
2483: FROM mtl_material_transactions_temp
2484: WHERE transfer_lpn_id = l_transfer_lpn_id
2485: AND transaction_temp_id <> p_temp_id);