DBA Data[Home] [Help]

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 983: UPDATE OE_ORDER_LINES_ALL

979: -- notification framework end
980: END IF; /* aso installed*/
981:
982:
983: UPDATE OE_ORDER_LINES_ALL
984: SET FULFILLED_FLAG = 'Y',
985: FULFILLED_QUANTITY = l_fulfilled_quantity,
986: FULFILLED_QUANTITY2 = l_fulfilled_quantity2, -- 5126873
987: FULFILLMENT_DATE = SYSDATE,

Line 1268: UPDATE OE_ORDER_LINES_ALL

1264: OR p_line_tbl(l_index).subscription_enable_flag = 'Y' THEN -- sol_ord_er #16014165 (for Model)
1265: /* 2417601 uses a different update statements for service line */
1266:
1267:
1268: UPDATE OE_ORDER_LINES_ALL
1269: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1270: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1271: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1272: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1331: UPDATE OE_ORDER_LINES_ALL

1327:
1328:
1329: ELSE -- 2417601
1330:
1331: UPDATE OE_ORDER_LINES_ALL
1332: SET FULFILLED_FLAG = p_line_tbl(l_index).fulfilled_flag,
1333: FULFILLED_QUANTITY = p_line_tbl(l_index).fulfilled_quantity,
1334: FULFILLED_QUANTITY2 = p_line_tbl(l_index).fulfilled_quantity2, -- 5126873
1335: FULFILLMENT_DATE = p_line_tbl(l_index).fulfillment_date,

Line 1904: from oe_order_lines_all

1900: END IF;
1901:
1902:
1903: select line_category_code into l_line_category_code
1904: from oe_order_lines_all
1905: where line_id = to_number(p_item_key);
1906:
1907: IF l_line_category_code = 'RETURN' THEN
1908: l_fulfill_attr_name := l_in_fulfill_attr_name;

Line 3058: FROM OE_ORDER_LINES_ALL

3054: INVENTORY_ITEM_ID,
3055: -- changes for AFD
3056: ACTUAL_SHIPMENT_DATE,
3057: ORDER_FIRMED_DATE
3058: FROM OE_ORDER_LINES_ALL
3059: WHERE LINE_ID = l_cursor_line_id;
3060:
3061: --
3062: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 4638: FROM oe_order_lines_all

4634: called in this cas and the record is still unlocked */
4635: BEGIN
4636: SELECT '1'
4637: INTO l_dummy
4638: FROM oe_order_lines_all
4639: WHERE line_id = l_line_rec.line_id
4640: FOR update nowait;
4641: EXCEPTION
4642: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN