APPS.WMS_PICK_DROP_PVT dependencies on DUAL

Line 823: FROM dual

819: ( p_org_id IN NUMBER
820: , p_lpn_id IN NUMBER
821: ) IS
822: SELECT 'x'
823: FROM dual
824: WHERE EXISTS
825: ( SELECT 'x'
826: FROM mtl_material_transactions_temp mmtt
827: WHERE mmtt.organization_id = p_org_id

Line 833: FROM dual

829: )
830: --Added for Bug 6717052
831: UNION ALL
832: SELECT 'x'
833: FROM dual
834: WHERE EXISTS
835: ( SELECT 'x'
836: FROM mtl_material_transactions_temp mmtt
837: WHERE mmtt.organization_id = p_org_id

Line 1657: FROM dual

1653: , p_outer_lpn_id IN NUMBER
1654: , p_org_id IN NUMBER
1655: ) IS
1656: SELECT 'x'
1657: FROM dual
1658: WHERE EXISTS
1659: ( SELECT 'x'
1660: FROM mtl_material_transactions_temp mmtt
1661: WHERE mmtt.organization_id = p_org_id

Line 2379: FROM dual

2375: THEN
2376: BEGIN
2377: SELECT 'x'
2378: INTO l_dummy
2379: FROM dual
2380: WHERE EXISTS
2381: ( SELECT 'x'
2382: FROM mtl_material_transactions_temp mmtt
2383: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2401: FROM dual

2397:
2398: BEGIN
2399: SELECT 'x'
2400: INTO l_dummy
2401: FROM dual
2402: WHERE EXISTS
2403: ( SELECT 'x'
2404: FROM mtl_material_transactions_temp mmtt
2405: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2632: FROM dual;

2628: SAVEPOINT split_mmtt_sp;
2629:
2630: SELECT mtl_material_transactions_s.NEXTVAL
2631: INTO l_new_temp_id
2632: FROM dual;
2633:
2634: IF l_debug = 1 THEN
2635: print_debug
2636: ( 'About to insert temp ID ' || to_char(l_new_temp_id)

Line 4822: FROM dual

4818:
4819: BEGIN
4820: SELECT 'x'
4821: INTO l_dummy
4822: FROM dual
4823: WHERE EXISTS
4824: ( SELECT 'x'
4825: FROM mtl_transaction_lots_temp mtlt
4826: WHERE mtlt.transaction_temp_id = p_temp_id

Line 4962: FROM dual;

4958: END IF;
4959:
4960: SELECT mtl_material_transactions_s.NEXTVAL
4961: INTO l_serial_temp_id
4962: FROM dual;
4963:
4964: IF l_debug = 1 THEN
4965: print_debug
4966: ( 'Generated new serial temp ID: ' || to_char(l_serial_temp_id)

Line 5558: FROM dual

5554: THEN
5555: BEGIN
5556: SELECT 'x'
5557: INTO l_dummy
5558: FROM dual
5559: WHERE EXISTS
5560: ( SELECT 'x'
5561: FROM mtl_material_transactions_temp mmtt
5562: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 6183: FROM dual

6179:
6180: BEGIN
6181: SELECT 'x'
6182: INTO l_dummy
6183: FROM dual
6184: WHERE EXISTS
6185: ( SELECT 'x'
6186: FROM mtl_material_transactions_temp mmtt
6187: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 7107: FROM dual;

7103: IF l_srl_temp_id IS NULL
7104: THEN
7105: SELECT mtl_material_transactions_s.NEXTVAL
7106: INTO l_srl_temp_id
7107: FROM dual;
7108:
7109: IF l_debug = 1 THEN
7110: print_debug
7111: ( 'New srl temp ID: ' || to_char(l_srl_temp_id)

Line 7370: FROM dual

7366: THEN
7367: BEGIN
7368: SELECT 'x'
7369: INTO l_dummy
7370: FROM dual
7371: WHERE EXISTS
7372: ( SELECT 'x'
7373: FROM mtl_material_transactions_temp mmtt
7374: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 8368: FROM DUAL;

8364: END;
8365:
8366: SELECT mtl_material_transactions_s.NEXTVAL
8367: INTO l_pack_temp_id
8368: FROM DUAL;
8369:
8370: IF l_debug = 1 THEN
8371: print_debug
8372: ( 'About to insert pack txn with temp ID: '

Line 9696: FROM dual;

9692: -- Generate a new transaction header ID
9693: --
9694: SELECT mtl_material_transactions_s.NEXTVAL
9695: INTO l_txn_header_id
9696: FROM dual;
9697:
9698: IF l_debug = 1 THEN
9699: print_debug
9700: ( 'Generated header ID: ' || to_char(l_txn_header_id)

Line 10188: FROM dual;

10184: END IF;
10185:
10186: SELECT mtl_material_transactions_s.NEXTVAL
10187: INTO l_txn_header_id
10188: FROM dual;
10189:
10190: IF l_debug = 1 THEN
10191: print_debug
10192: ( 'Generated header ID: ' || to_char(l_txn_header_id)