APPS.OE_LINE_FULLFILL dependencies on OE_ORDER_LINES_ALL

Line 296: FROM OE_ORDER_LINES_ALL

292: UNIT_SELLING_PRICE,
293: INVENTORY_ITEM_ID,
294: ORDER_FIRMED_DATE,
295: ACTUAL_SHIPMENT_DATE
296: FROM OE_ORDER_LINES_ALL
297: WHERE SERVICE_REFERENCE_LINE_ID = p_line_id
298: AND SERVICE_REFERENCE_TYPE_CODE = 'ORDER' -- added in 115.46
299: AND HEADER_ID = l_header_id -- 1717444
300: AND TOP_MODEL_LINE_ID IS NULL; --3449588

Line 962: UPDATE OE_ORDER_LINES_ALL

958: -- notification framework end
959: END IF; /* aso installed*/
960:
961:
962: UPDATE OE_ORDER_LINES_ALL
963: SET FULFILLED_FLAG = 'Y',
964: FULFILLED_QUANTITY = l_fulfilled_quantity,
965: FULFILLED_QUANTITY2 = l_fulfilled_quantity2, -- 5126873
966: FULFILLMENT_DATE = SYSDATE,

Line 1207: UPDATE OE_ORDER_LINES_ALL

1203: IF p_line_tbl(l_index).item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN --3471423
1204: /* 2417601 uses a different update statements for service line */
1205:
1206:
1207: UPDATE OE_ORDER_LINES_ALL
1208: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1209: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1210: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1211: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1255: UPDATE OE_ORDER_LINES_ALL

1251:
1252:
1253: ELSE -- 2417601
1254:
1255: UPDATE OE_ORDER_LINES_ALL
1256: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1257: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1258: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1259: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1817: from oe_order_lines_all

1813: END IF;
1814:
1815:
1816: select line_category_code into l_line_category_code
1817: from oe_order_lines_all
1818: where line_id = to_number(p_item_key);
1819:
1820: IF l_line_category_code = 'RETURN' THEN
1821: l_fulfill_attr_name := l_in_fulfill_attr_name;

Line 2904: FROM OE_ORDER_LINES_ALL

2900: INVENTORY_ITEM_ID,
2901: -- changes for AFD
2902: ACTUAL_SHIPMENT_DATE,
2903: ORDER_FIRMED_DATE
2904: FROM OE_ORDER_LINES_ALL
2905: WHERE LINE_ID = l_cursor_line_id;
2906:
2907: --
2908: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;