DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on OE_ORDER_LINES_ALL

Line 411: FROM oe_order_lines_all ool,

407: SELECT ooh.order_number, ool.line_number, wwtt.transaction_temp_id,
408: wwtt.task_type_id
409: BULK COLLECT INTO l_source_header, l_line_number, l_temp_id,
410: l_task_type_id
411: FROM oe_order_lines_all ool,
412: oe_order_headers_all ooh,
413: wms_waveplan_tasks_temp wwtt
414: WHERE ool.line_id = wwtt.reference_id
415: AND ooh.header_id = ool.header_id

Line 4805: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';

4801: OR p_to_number_of_order_lines IS NOT NULL
4802: THEN
4803: l_from_outbound :=
4804: l_from_outbound
4805: || ', (SELECT COUNT(line_id) line_sum, header_id FROM oe_order_lines_all ';
4806:
4807: IF p_customer_id IS NOT NULL
4808: THEN
4809: l_from_outbound :=

Line 5002: l_where_outbound := l_where_outbound || ' AND EXISTS (SELECT 1 FROM oe_order_lines_all oel ';

4998: /*Bug 14534307 added following lines Begin*/
4999: l_where_outbound := l_where_outbound || ' AND wdd.released_status in (''Y'', ''C'') ';
5000: l_where_outbound := l_where_outbound || ' AND wdd.container_flag = ''N'' ';
5001: l_where_outbound := l_where_outbound || ' AND wdd.move_order_line_id = mmt.move_order_line_id ';
5002: l_where_outbound := l_where_outbound || ' AND EXISTS (SELECT 1 FROM oe_order_lines_all oel ';
5003: l_where_outbound := l_where_outbound || ' WHERE wdd.source_header_id = oel.header_id ';
5004: l_where_outbound := l_where_outbound || ' AND wdd.source_line_id = oel.line_id ';
5005: l_where_outbound := l_where_outbound || ' AND (oel.line_id = mmt.trx_source_line_id ';
5006: l_where_outbound := l_where_outbound || ' OR mmt.trx_source_line_id IN ';

Line 5007: l_where_outbound := l_where_outbound || ' ( SELECT line_id from oe_order_lines_all oel1 WHERE oel.header_id = oel1.header_id ';

5003: l_where_outbound := l_where_outbound || ' WHERE wdd.source_header_id = oel.header_id ';
5004: l_where_outbound := l_where_outbound || ' AND wdd.source_line_id = oel.line_id ';
5005: l_where_outbound := l_where_outbound || ' AND (oel.line_id = mmt.trx_source_line_id ';
5006: l_where_outbound := l_where_outbound || ' OR mmt.trx_source_line_id IN ';
5007: l_where_outbound := l_where_outbound || ' ( SELECT line_id from oe_order_lines_all oel1 WHERE oel.header_id = oel1.header_id ';
5008: l_where_outbound := l_where_outbound || ' START WITH oel1.line_id = oel.line_id CONNECT BY PRIOR oel1.split_from_line_id = oel1.line_id ))) ';
5009: /*Bug 14534307 added lines End*/
5010:
5011: /* start of 9493192 */

Line 6016: l_from_generic := l_from_generic || ', oe_order_lines_all ool';

6012: ELSIF p_from_rma_header_id IS NOT NULL
6013: OR p_to_rma_header_id IS NOT NULL
6014: THEN
6015: l_from_generic := l_from_generic || ', oe_order_headers_all ooh';
6016: l_from_generic := l_from_generic || ', oe_order_lines_all ool';
6017: ELSIF p_from_requisition_header_id IS NOT NULL
6018: OR p_to_requisition_header_id IS NOT NULL
6019: THEN
6020: l_from_generic := l_from_generic || ', rcv_shipment_headers rsh';