APPS.CTO_AUTO_PROCURE_PK dependencies on OE_ORDER_HEADERS_ALL

Line 556: oe_order_headers_all oeh

552: ,oel.shipped_quantity
553: ,oel.flow_status_code
554: ,oel.shipping_interfaced_flag
555: from oe_order_lines_all oel,
556: oe_order_headers_all oeh
557: where oel.header_id = oeh.header_id
558: and oel.line_id = p_cursor_line_id
559: FOR UPDATE OF oel.line_id;
560:

Line 4457: oe_order_headers_all oeh,

4453:
4454: OPEN pprollup_oe_cur FOR
4455: SELECT oel.line_id, oel.inventory_item_id,oel.ato_line_id
4456: from oe_order_lines_all oel,
4457: oe_order_headers_all oeh,
4458: mtl_system_items msi
4459: where oel.inventory_item_id = msi.inventory_item_id
4460: and oel.ship_from_org_id = msi.organization_id
4461: and oel.header_id = oeh.header_id

Line 5262: ' from oe_order_headers_all oeh, '||

5258: if p_sales_order is not null then
5259: drive_mark := drive_mark + 1;
5260: sql_stmt := sql_stmt || ' and oel.header_id in' ||
5261: ' (select oeh.header_id '||
5262: ' from oe_order_headers_all oeh, '||
5263: ' oe_transaction_types_tl oet, '||
5264: ' mtl_sales_orders mso '||
5265: ' where oeh.order_number = to_char( :p_sales_order) '||
5266: ' and oeh.order_type_id = oet.transaction_type_id '||