APPS.OE_DEFAULT_LINE dependencies on OE_ORDER_HEADERS

Line 227: FROM oe_order_headers_all

223: end if ;
224:
225: /*SELECT booked_flag
226: INTO l_booked_flag
227: FROM oe_order_headers_all
228: WHERE header_id = g_line_rec.header_id; */
229: ELSE
230: l_booked_flag := 'N';
231: END IF;

Line 2804: oe_order_headers h

2800: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2801: FROM oe_order_lines_all l,
2802: mtl_unit_transactions_all_v u,
2803: mtl_material_transactions m,
2804: oe_order_headers h
2805: WHERE l.Inventory_item_id = to_number(attr1)
2806: AND m.transaction_source_type_id=2
2807: AND m.trx_source_line_id=l.line_id
2808: AND m.transaction_id = u.transaction_id

Line 2826: oe_order_headers h

2822: FROM mtl_material_transactions m,
2823: mtl_transaction_lot_val_v t,
2824: mtl_unit_transactions_all_v u,
2825: oe_order_lines_all l,
2826: oe_order_headers h
2827: WHERE u.Inventory_item_id = to_number(attr1)
2828: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2829: AND u.serial_number = attr2
2830: AND t.serial_transaction_id = u.transaction_id

Line 2868: oe_order_headers ooh,

2864:
2865: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2866: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2867: FROM oe_order_lines_all ool,
2868: oe_order_headers ooh,
2869: oe_transaction_types_tl ott
2870: WHERE ool.line_id = ord_line_id
2871: AND ooh.header_id = ool.header_id
2872: AND ott.transaction_type_id = ooh.order_type_id

Line 2917: oe_order_headers h

2913: INTO p_ref_line_id
2914: FROM ra_customer_trx_lines_all rctl,
2915: ra_customer_trx_all rct,
2916: oe_order_lines_all l,
2917: oe_order_headers h
2918: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
2919: and rctl.customer_trx_id = rct.customer_trx_id
2920: AND l.line_id = rctl.interface_line_attribute6
2921: AND l.header_id = h.header_id