APPS.OE_LINE_FULLFILL dependencies on OE_ORDER_HEADERS_ALL

Line 786: from oe_order_headers_all

782:
783:
784: -- CHANGES for AFD
785: select ordered_date into l_ordered_date
786: from oe_order_headers_all
787: where header_id = p_line_rec.header_id;
788:
789: l_actual_fulfillment_date := nvl(p_line_rec.actual_shipment_date,nvl(p_line_rec.order_firmed_date,l_ordered_date));
790: -- end CHANGES for AFD

Line 981: from oe_order_headers_all

977: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
978: /* Start Improved OM,IB,OKS changes */
979: select order_number
980: into l_order_number
981: from oe_order_headers_all
982: where header_id = p_line_rec.header_id;
983:
984: l_Service_Order_Lines(1).Order_Header_ID := p_line_rec.header_id;
985: l_Service_Order_Lines(1).Order_Line_ID := p_line_rec.line_id;

Line 1063: from oe_order_headers_all

1059: -- CHANGES for AFD
1060: l := p_line_tbl.FIRST;
1061:
1062: select ordered_date into l_ordered_date
1063: from oe_order_headers_all
1064: where header_id = p_line_tbl(l).header_id;
1065: -- end CHANGES for AFD
1066:
1067:

Line 1224: from oe_order_headers_all

1220:
1221: /* Start Improved OM,IB,OKS changes */
1222: select order_number
1223: into l_order_number
1224: from oe_order_headers_all
1225: where header_id = p_line_tbl(l_index).header_id;
1226:
1227: l_Service_Order_Lines(1).Order_Header_ID := p_line_tbl(l_index).header_id;
1228: l_Service_Order_Lines(1).Order_Line_ID := p_line_tbl(l_index).line_id;

Line 2145: from oe_order_headers_all

2141:
2142: -- CHANGES for AFD
2143: IF l_ordered_date is null THEN
2144: select ordered_date into l_ordered_date
2145: from oe_order_headers_all
2146: where header_id = l_line_tbl(1).header_id;
2147: END IF;
2148:
2149: 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));