APPS.CTO_AUTO_PROCURE_PK dependencies on OE_ORDER_HEADERS_ALL

Line 500: oe_order_headers_all oeh

496: ,oel.ordered_quantity2 --opm
497: ,oel.ordered_quantity_uom2 --opm
498: ,oel.preferred_grade --opm
499: from oe_order_lines_all oel,
500: oe_order_headers_all oeh
501: where oel.header_id = oeh.header_id
502: and oel.line_id = p_cursor_line_id
503: FOR UPDATE OF oel.line_id;
504:

Line 4047: oe_order_headers_all oeh,

4043:
4044: OPEN pprollup_oe_cur FOR
4045: SELECT oel.line_id, oel.inventory_item_id,oel.ato_line_id
4046: from oe_order_lines_all oel,
4047: oe_order_headers_all oeh,
4048: mtl_system_items msi
4049: where oel.inventory_item_id = msi.inventory_item_id
4050: and oel.ship_from_org_id = msi.organization_id
4051: and oel.header_id = oeh.header_id

Line 4843: ' from oe_order_headers_all oeh, '||

4839: if p_sales_order is not null then
4840: drive_mark := drive_mark + 1;
4841: sql_stmt := sql_stmt || ' and oel.header_id in' ||
4842: ' (select oeh.header_id '||
4843: ' from oe_order_headers_all oeh, '||
4844: ' oe_transaction_types_tl oet, '||
4845: ' mtl_sales_orders mso '||
4846: ' where oeh.order_number = to_char( :p_sales_order) '||
4847: ' and oeh.order_type_id = oet.transaction_type_id '||