APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_HEADERS_ALL

Line 3740: from oe_order_headers_all h,

3736: x_line_val_rec.ref_line_number,
3737: x_line_val_rec.ref_shipment_number,
3738: x_line_val_rec.ref_option_number,
3739: x_line_val_rec.ref_component_number
3740: from oe_order_headers_all h,
3741: oe_order_lines_all l
3742: where l.line_id=p_line_rec.reference_line_id
3743: and h.header_id=l.header_id;
3744: EXCEPTION

Line 4957: from oe_order_headers_all oh,oe_order_types_v ot

4953: IF p_line_rec.svc_ref_order_number IS NOT NULL
4954: AND p_line_rec.svc_ref_order_type IS NOT NULL THEN
4955: BEGIN
4956: select /* MOAC_SQL_CHANGE */ header_id into x_line_val_rec.svc_header_id
4957: from oe_order_headers_all oh,oe_order_types_v ot
4958: where order_number=p_line_rec.svc_ref_order_number
4959: and oh.order_type_id=ot.order_type_id
4960: and ot.name=p_line_rec.svc_ref_order_type;
4961: EXCEPTION

Line 5142: FROM oe_order_headers_all orig_head,

5138: x_line_val_rec.Retro_Shipment_Number,
5139: x_line_val_rec.Retro_Option_Number,
5140: x_line_val_rec.Retro_Component_Number,
5141: x_line_val_rec.Retro_Service_Number
5142: FROM oe_order_headers_all orig_head,
5143: oe_order_lines_all orig_lin
5144: WHERE line_id =
5145: (
5146: SELECT orig_sys_line_ref