DBA Data[Home] [Help]

APPS.CTO_WIP_WRAPPER dependencies on OE_ORDER_HEADERS_ALL

Line 505: 'from oe_order_headers_all oeh ' ||

501:
502: if (l_order_number IS NOT NULL) then
503: sql_stmt := sql_stmt ||
504: 'and oel.header_id in (select oeh.header_id '||
505: 'from oe_order_headers_all oeh ' ||
506: 'where oeh.order_number = :l_order_number) ';
507: drive_mark := drive_mark + 1;
508: end if;
509:

Line 1528: oe_order_headers_all oeh,

1524: oel.org_id -- bugfix 3014000
1525: from wip_job_schedule_interface wei,
1526: oe_order_lines_all oel,
1527: mtl_sales_orders mso,
1528: oe_order_headers_all oeh,
1529: --oe_order_types_v oet
1530: oe_transaction_types_tl oet,
1531: mtl_system_items msi -- bugfix 1661094:
1532: where wei.group_id = p_wip_seq

Line 1901: oe_order_headers_all oeh,

1897: msi.primary_uom_code,
1898: null,
1899: null)),0)
1900: from mtl_reservations mr,
1901: oe_order_headers_all oeh,
1902: oe_order_lines_all oel,
1903: mtl_system_items msi --bugfix 2074290: added msi
1904: where oel.line_id = pLineId
1905: and oel.header_id = oeh.header_id