APPS.WMS_PICK_DROP_PVT dependencies on DUAL

Line 806: FROM dual

802: ( p_org_id IN NUMBER
803: , p_lpn_id IN NUMBER
804: ) IS
805: SELECT 'x'
806: FROM dual
807: WHERE EXISTS
808: ( SELECT 'x'
809: FROM mtl_material_transactions_temp mmtt
810: WHERE mmtt.organization_id = p_org_id

Line 816: FROM dual

812: )
813: --Added for Bug 6717052
814: UNION ALL
815: SELECT 'x'
816: FROM dual
817: WHERE EXISTS
818: ( SELECT 'x'
819: FROM mtl_material_transactions_temp mmtt
820: WHERE mmtt.organization_id = p_org_id

Line 1516: FROM dual

1512: , p_outer_lpn_id IN NUMBER
1513: , p_org_id IN NUMBER
1514: ) IS
1515: SELECT 'x'
1516: FROM dual
1517: WHERE EXISTS
1518: ( SELECT 'x'
1519: FROM mtl_material_transactions_temp mmtt
1520: WHERE mmtt.organization_id = p_org_id

Line 2236: FROM dual

2232: THEN
2233: BEGIN
2234: SELECT 'x'
2235: INTO l_dummy
2236: FROM dual
2237: WHERE EXISTS
2238: ( SELECT 'x'
2239: FROM mtl_material_transactions_temp mmtt
2240: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2258: FROM dual

2254:
2255: BEGIN
2256: SELECT 'x'
2257: INTO l_dummy
2258: FROM dual
2259: WHERE EXISTS
2260: ( SELECT 'x'
2261: FROM mtl_material_transactions_temp mmtt
2262: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2489: FROM dual;

2485: SAVEPOINT split_mmtt_sp;
2486:
2487: SELECT mtl_material_transactions_s.NEXTVAL
2488: INTO l_new_temp_id
2489: FROM dual;
2490:
2491: IF l_debug = 1 THEN
2492: print_debug
2493: ( 'About to insert temp ID ' || to_char(l_new_temp_id)

Line 4544: FROM dual

4540:
4541: BEGIN
4542: SELECT 'x'
4543: INTO l_dummy
4544: FROM dual
4545: WHERE EXISTS
4546: ( SELECT 'x'
4547: FROM mtl_transaction_lots_temp mtlt
4548: WHERE mtlt.transaction_temp_id = p_temp_id

Line 4684: FROM dual;

4680: END IF;
4681:
4682: SELECT mtl_material_transactions_s.NEXTVAL
4683: INTO l_serial_temp_id
4684: FROM dual;
4685:
4686: IF l_debug = 1 THEN
4687: print_debug
4688: ( 'Generated new serial temp ID: ' || to_char(l_serial_temp_id)

Line 5280: FROM dual

5276: THEN
5277: BEGIN
5278: SELECT 'x'
5279: INTO l_dummy
5280: FROM dual
5281: WHERE EXISTS
5282: ( SELECT 'x'
5283: FROM mtl_material_transactions_temp mmtt
5284: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 5905: FROM dual

5901:
5902: BEGIN
5903: SELECT 'x'
5904: INTO l_dummy
5905: FROM dual
5906: WHERE EXISTS
5907: ( SELECT 'x'
5908: FROM mtl_material_transactions_temp mmtt
5909: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 6829: FROM dual;

6825: IF l_srl_temp_id IS NULL
6826: THEN
6827: SELECT mtl_material_transactions_s.NEXTVAL
6828: INTO l_srl_temp_id
6829: FROM dual;
6830:
6831: IF l_debug = 1 THEN
6832: print_debug
6833: ( 'New srl temp ID: ' || to_char(l_srl_temp_id)

Line 7092: FROM dual

7088: THEN
7089: BEGIN
7090: SELECT 'x'
7091: INTO l_dummy
7092: FROM dual
7093: WHERE EXISTS
7094: ( SELECT 'x'
7095: FROM mtl_material_transactions_temp mmtt
7096: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 8074: FROM DUAL;

8070: END;
8071:
8072: SELECT mtl_material_transactions_s.NEXTVAL
8073: INTO l_pack_temp_id
8074: FROM DUAL;
8075:
8076: IF l_debug = 1 THEN
8077: print_debug
8078: ( 'About to insert pack txn with temp ID: '

Line 9377: FROM dual;

9373: -- Generate a new transaction header ID
9374: --
9375: SELECT mtl_material_transactions_s.NEXTVAL
9376: INTO l_txn_header_id
9377: FROM dual;
9378:
9379: IF l_debug = 1 THEN
9380: print_debug
9381: ( 'Generated header ID: ' || to_char(l_txn_header_id)

Line 9865: FROM dual;

9861: END IF;
9862:
9863: SELECT mtl_material_transactions_s.NEXTVAL
9864: INTO l_txn_header_id
9865: FROM dual;
9866:
9867: IF l_debug = 1 THEN
9868: print_debug
9869: ( 'Generated header ID: ' || to_char(l_txn_header_id)