APPS.OE_DEFAULT_LINE dependencies on OE_ORDER_HEADERS

Line 229: FROM oe_order_headers_all

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

Line 2923: oe_order_headers h

2919: SELECT /* MOAC_SQL_CHANGE */ DISTINCT l.line_id line_id
2920: FROM oe_order_lines_all l,
2921: mtl_unit_transactions_all_v u,
2922: mtl_material_transactions m,
2923: oe_order_headers h
2924: WHERE l.Inventory_item_id = to_number(attr1)
2925: AND m.transaction_source_type_id=2
2926: AND m.trx_source_line_id=l.line_id
2927: AND m.transaction_id = u.transaction_id

Line 2945: oe_order_headers h

2941: FROM mtl_material_transactions m,
2942: mtl_transaction_lot_val_v t,
2943: mtl_unit_transactions_all_v u,
2944: oe_order_lines_all l,
2945: oe_order_headers h
2946: WHERE u.Inventory_item_id = to_number(attr1)
2947: AND u.ORGANIZATION_ID = t.ORGANIZATION_ID
2948: AND u.serial_number = attr2
2949: AND t.serial_transaction_id = u.transaction_id

Line 2987: oe_order_headers ooh,

2983:
2984: CURSOR C_ORDER_INFO(ord_line_id NUMBER) IS
2985: SELECT /* MOAC_SQL_CHANGE */ ooh.order_number, ott.name
2986: FROM oe_order_lines_all ool,
2987: oe_order_headers ooh,
2988: oe_transaction_types_tl ott
2989: WHERE ool.line_id = ord_line_id
2990: AND ooh.header_id = ool.header_id
2991: AND ott.transaction_type_id = ooh.order_type_id

Line 3036: oe_order_headers h

3032: INTO p_ref_line_id
3033: FROM ra_customer_trx_lines_all rctl,
3034: ra_customer_trx_all rct,
3035: oe_order_lines_all l,
3036: oe_order_headers h
3037: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
3038: and rctl.customer_trx_id = rct.customer_trx_id
3039: AND l.line_id = rctl.interface_line_attribute6
3040: AND l.header_id = h.header_id