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 1522: FROM DUAL

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

Line 1569: FROM DUAL;

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

Line 1626: FROM DUAL;

1622: END IF;
1623:
1624: SELECT mtl_material_transactions_s.NEXTVAL
1625: INTO new_txn_temp_id
1626: FROM DUAL;
1627:
1628: IF (l_debug = 1) THEN
1629: mydebug('New Txn Temp id is ' || new_txn_temp_id);
1630: END IF;

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

1943:
1944: /**2706001 checking group mark ids here **/
1945: l_already_used := 'N';
1946: BEGIN
1947: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
1948: (SELECT 1
1949: FROM mtl_serial_numbers
1950: WHERE
1951: --Bug 2940878 fix added current_organization_id ,

Line 2050: FROM dual;

2046:
2047: /**2706001 moved this out of below loop **/
2048: SELECT mtl_material_transactions_s.NEXTVAL
2049: INTO ser_transaction_temp_id
2050: FROM dual;
2051:
2052: /**2706001 was using cnt6 earlier **/
2053: FOR cnt6 IN 1 .. msnt_table.COUNT LOOP
2054: ser_row := msnt_table(cnt6);

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

2056: IF ser_row.transaction_temp_id = lot_row.serial_transaction_temp_id THEN
2057: /**2706001 checking group mark ids here **/
2058: l_already_used := 'N';
2059: BEGIN
2060: SELECT 'Y' INTO l_already_used FROM dual WHERE exists
2061: (SELECT 1
2062: FROM mtl_serial_numbers
2063: WHERE
2064: --Bug 2940878 fix added current_organization_id ,

Line 2466: FROM DUAL

2462:
2463: BEGIN
2464: SELECT 'Y'
2465: INTO l_multiple_rows
2466: FROM DUAL
2467: WHERE EXISTS(SELECT transaction_temp_id
2468: FROM mtl_material_transactions_temp
2469: WHERE transfer_lpn_id = l_transfer_lpn_id
2470: AND transaction_temp_id <> p_temp_id);