APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_HEADERS

Line 3452: from oe_order_headers

3448: IF(g_header_id is NULL or p_line_rec.header_id <> g_header_id) THEN
3449: IF p_line_rec.header_id is not null THEN
3450: select transactional_curr_code
3451: into x_line_val_rec.transactional_curr_code
3452: from oe_order_headers
3453: where header_id=p_line_rec.header_id;
3454: g_header_id := p_line_rec.header_id;
3455: g_currency_code :=x_line_val_rec. transactional_curr_code;
3456: END IF;

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 4719: from oe_order_headers

4715: from oe_order_sources
4716: where order_source_id=2;
4717:
4718: Select order_number into x_line_val_rec.order_source_ref
4719: from oe_order_headers
4720: where header_id=p_line_rec.source_document_id;
4721:
4722: Select line_number into x_line_val_rec.order_source_line_ref
4723: from oe_order_lines

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

Line 6014: FROM oe_order_headers

6010: BEGIN
6011:
6012: SELECT order_date_type_code
6013: INTO l_order_date_type_code
6014: FROM oe_order_headers
6015: WHERE header_id = p_header_id;
6016:
6017: RETURN l_order_date_type_code;
6018: