DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on DUAL

Line 223: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10

219: }}
220:
221: */
222: IF (p_operation_type_id = g_op_type_crossdock AND
223: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
224: THEN
225:
226: IF (l_debug=1) THEN
227: print_debug('Stamp subsequent OP plan ID '||p_subsequent_op_plan_id||' to child task. ',l_module_name,9);

Line 1887: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10

1883: }}
1884:
1885: */
1886: IF (p_next_operation_type_id = g_op_type_crossdock AND
1887: p_subsequent_op_plan_id IS NOT NULL) -- this is necessary because this file is dual maintained for 11.5.10
1888: THEN
1889:
1890: INV_TRX_UTIL_PUB.copy_insert_line_trx
1891: (

Line 2799: FROM dual

2795: p_mmtt_error_code,
2796: p_mmtt_error_explanation,
2797: NULL,
2798: NULL
2799: FROM dual
2800: )
2801: WHERE mmtt.transaction_temp_id = p_source_task_id;
2802: ELSE
2803: IF l_debug = 1 THEN