APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_HEADERS_ALL

Line 3641: from oe_order_headers_all h,

3637: x_line_val_rec.ref_line_number,
3638: x_line_val_rec.ref_shipment_number,
3639: x_line_val_rec.ref_option_number,
3640: x_line_val_rec.ref_component_number
3641: from oe_order_headers_all h,
3642: oe_order_lines_all l
3643: where l.line_id=p_line_rec.reference_line_id
3644: and h.header_id=l.header_id;
3645: EXCEPTION

Line 4679: from oe_order_headers_all oh,oe_order_types_v ot

4675: IF p_line_rec.svc_ref_order_number IS NOT NULL
4676: AND p_line_rec.svc_ref_order_type IS NOT NULL THEN
4677: BEGIN
4678: select /* MOAC_SQL_CHANGE */ header_id into x_line_val_rec.svc_header_id
4679: from oe_order_headers_all oh,oe_order_types_v ot
4680: where order_number=p_line_rec.svc_ref_order_number
4681: and oh.order_type_id=ot.order_type_id
4682: and ot.name=p_line_rec.svc_ref_order_type;
4683: EXCEPTION

Line 4864: FROM oe_order_headers_all orig_head,

4860: x_line_val_rec.Retro_Shipment_Number,
4861: x_line_val_rec.Retro_Option_Number,
4862: x_line_val_rec.Retro_Component_Number,
4863: x_line_val_rec.Retro_Service_Number
4864: FROM oe_order_headers_all orig_head,
4865: oe_order_lines_all orig_lin
4866: WHERE line_id =
4867: (
4868: SELECT orig_sys_line_ref