DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_TYPES_V

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