APPS.OE_LINE_FULLFILL dependencies on OE_ORDER_HEADERS_ALL

Line 794: from oe_order_headers_all

790:
791:
792: -- CHANGES for AFD
793: select ordered_date into l_ordered_date
794: from oe_order_headers_all
795: where header_id = p_line_rec.header_id;
796:
797: l_actual_fulfillment_date := nvl(p_line_rec.actual_shipment_date,nvl(p_line_rec.order_firmed_date,l_ordered_date));
798: -- end CHANGES for AFD

Line 1019: from oe_order_headers_all

1015: OR p_line_rec.subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1016: /* Start Improved OM,IB,OKS changes */
1017: select order_number
1018: into l_order_number
1019: from oe_order_headers_all
1020: where header_id = p_line_rec.header_id;
1021:
1022: l_Service_Order_Lines(1).Order_Header_ID := p_line_rec.header_id;
1023: l_Service_Order_Lines(1).Order_Line_ID := p_line_rec.line_id;

Line 1106: from oe_order_headers_all

1102: -- CHANGES for AFD
1103: l := p_line_tbl.FIRST;
1104:
1105: select ordered_date into l_ordered_date
1106: from oe_order_headers_all
1107: where header_id = p_line_tbl(l).header_id;
1108: -- end CHANGES for AFD
1109:
1110:

Line 1300: from oe_order_headers_all

1296:
1297: /* Start Improved OM,IB,OKS changes */
1298: select order_number
1299: into l_order_number
1300: from oe_order_headers_all
1301: where header_id = p_line_tbl(l_index).header_id;
1302:
1303: l_Service_Order_Lines(1).Order_Header_ID := p_line_tbl(l_index).header_id;
1304: l_Service_Order_Lines(1).Order_Line_ID := p_line_tbl(l_index).line_id;

Line 2238: from oe_order_headers_all

2234:
2235: -- CHANGES for AFD
2236: IF l_ordered_date is null THEN
2237: select ordered_date into l_ordered_date
2238: from oe_order_headers_all
2239: where header_id = l_line_tbl(1).header_id;
2240: END IF;
2241:
2242: l_line_tbl(1).actual_fulfillment_date := nvl(l_line_tbl(1).actual_shipment_date,nvl(l_line_tbl(1).order_firmed_date,l_ordered_date));