DBA Data[Home] [Help]

APPS.CTO_WIP_WRAPPER dependencies on OE_ORDER_HEADERS_ALL

Line 485: 'from oe_order_headers_all oeh ' ||

481:
482: if (l_order_number IS NOT NULL) then
483: sql_stmt := sql_stmt ||
484: 'and oel.header_id in (select oeh.header_id '||
485: 'from oe_order_headers_all oeh ' ||
486: 'where oeh.order_number = :l_order_number) ';
487: drive_mark := drive_mark + 1;
488: end if;
489:

Line 1384: oe_order_headers_all oeh,

1380: oel.org_id -- bugfix 3014000
1381: from wip_job_schedule_interface wei,
1382: oe_order_lines_all oel,
1383: mtl_sales_orders mso,
1384: oe_order_headers_all oeh,
1385: --oe_order_types_v oet
1386: oe_transaction_types_tl oet,
1387: mtl_system_items msi -- bugfix 1661094:
1388: where wei.group_id = p_wip_seq

Line 1755: oe_order_headers_all oeh,

1751: msi.primary_uom_code,
1752: null,
1753: null)),0)
1754: from mtl_reservations mr,
1755: oe_order_headers_all oeh,
1756: oe_order_lines_all oel,
1757: mtl_system_items msi --bugfix 2074290: added msi
1758: where oel.line_id = pLineId
1759: and oel.header_id = oeh.header_id