DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_TYPES_V

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