APPS.OE_ORDER_WF_UTIL dependencies on OE_ORDER_LINES_ALL

Line 292: FROM oe_order_lines_all

288: l_line_id := to_number(wf_engine.setctx_itemkey);
289: END;
290: SELECT header_id, line_number, shipment_number, option_number, service_number
291: into l_header_id, l_line_number, l_shipment_number, l_option_number, l_service_number
292: FROM oe_order_lines_all
293: WHERE line_id = l_line_id;
294:
295: SELECT order_number, order_type_id, order_category_code
296: into l_order_number, l_order_type_id, l_order_category_code

Line 1144: from oe_order_lines_all

1140: Select line_type_id, item_type_code,
1141: ato_line_id, line_id
1142: into l_type_id, l_item_type_code,
1143: l_ato_line_id, l_line_id
1144: from oe_order_lines_all
1145: where line_id = OE_GLOBALS.G_START_LINE_FLOWS_TBL(ctr).line_id;
1146:
1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add( 'STARTING LINE FLOW '||'LINE ID = ' ||OE_GLOBALS.G_START_LINE_FLOWS_TBL ( CTR ).line_id ) ;

Line 1356: FROM oe_order_lines_all

1352:
1353: ELSIF p_type = 'LINE' THEN
1354: SELECT transaction_phase_code
1355: INTO l_transaction_phase_code
1356: FROM oe_order_lines_all
1357: WHERE line_id = p_id;
1358:
1359: IF nvl(l_transaction_phase_code, 'F') <> 'N' THEN
1360:

Line 1479: FROM OE_ORDER_LINES_ALL

1475: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1476: --
1477: Cursor lines IS
1478: SELECT line_id, lock_control
1479: FROM OE_ORDER_LINES_ALL
1480: WHERE HEADER_ID = p_header_id
1481: FOR UPDATE NOWAIT;
1482:
1483: l_line_id NUMBER;

Line 1578: UPDATE OE_ORDER_LINES_ALL

1574: EXIT WHEN Lines%NOTFOUND;
1575: End Loop;
1576: Close Lines;
1577:
1578: UPDATE OE_ORDER_LINES_ALL
1579: SET FLOW_STATUS_CODE = p_flow_status_code,
1580: LOCK_CONTROL = LOCK_CONTROL + 1
1581: WHERE HEADER_ID = p_header_id;
1582:

Line 1795: FROM OE_ORDER_LINES_ALL

1791: l_order_source_id,
1792: l_orig_sys_shipment_ref,
1793: l_change_sequence,
1794: l_source_document_type_id
1795: FROM OE_ORDER_LINES_ALL
1796: WHERE line_id = p_line_id
1797: FOR UPDATE NOWAIT;
1798:
1799: OE_MSG_PUB.set_msg_context

Line 1860: UPDATE OE_ORDER_LINES_ALL

1856: END IF;
1857:
1858: IF p_line_id is NOT NULL THEN
1859:
1860: UPDATE OE_ORDER_LINES_ALL
1861: SET FLOW_STATUS_CODE = p_flow_status_code,
1862: last_update_date = SYSDATE,
1863: last_updated_by = FND_GLOBAL.USER_ID,
1864: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2209: FROM OE_ORDER_LINES_ALL

2205: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2206: ELSIF itemtype = 'OEOL' THEN
2207: SELECT HEADER_ID
2208: INTO v_header_id
2209: FROM OE_ORDER_LINES_ALL
2210: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2211:
2212: SELECT CREATED_BY
2213: INTO v_id

Line 2244: FROM OE_ORDER_LINES_ALL

2240: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2241: ELSIF itemtype='OEOL' THEN
2242: SELECT CREATED_BY
2243: INTO v_id
2244: FROM OE_ORDER_LINES_ALL
2245: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2246: END IF;
2247:
2248: SELECT USER_NAME

Line 2268: FROM OE_ORDER_LINES_ALL

2264: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2265: ELSIF itemtype='OEOL' THEN
2266: SELECT SALESREP_ID
2267: INTO v_id
2268: FROM OE_ORDER_LINES_ALL
2269: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2270: END IF;
2271: */
2272: END IF;

Line 2307: FROM OE_ORDER_LINES_ALL

2303: l_lock_control NUMBER;
2304:
2305: Cursor lines IS
2306: SELECT line_id, lock_control
2307: FROM OE_ORDER_LINES_ALL
2308: WHERE HEADER_ID = l_header_id
2309: FOR UPDATE NOWAIT;
2310:
2311: Cursor blanket_lines IS

Line 2391: UPDATE OE_ORDER_LINES_ALL

2387: EXIT WHEN Lines%NOTFOUND;
2388: End Loop;
2389: Close Lines;
2390:
2391: UPDATE OE_ORDER_LINES_ALL
2392: SET FLOW_STATUS_CODE = p_flow_status_code,
2393: LOCK_CONTROL = LOCk_CONTROL + 1
2394: WHERE HEADER_ID = l_header_id;
2395:

Line 2409: UPDATE OE_ORDER_LINES_ALL

2405: l_updated_flag := 'Y';
2406: l_header_rec.open_flag := p_open_flag;
2407:
2408: -- XDING bug FP5172433
2409: UPDATE OE_ORDER_LINES_ALL
2410: SET OPEN_FLAG = p_open_flag
2411: WHERE HEADER_ID = l_header_id;
2412: -- XDING bug FP5172433
2413:

Line 3449: FROM oe_order_lines_all ol,

3445: ol.SHIP_FROM_ORG_ID,
3446: ol.PROJECT_ID,
3447: ol.ACTUAL_SHIPMENT_DATE,
3448: ol.FULFILLMENT_DATE
3449: FROM oe_order_lines_all ol,
3450: mtl_system_items_kfv msi
3451: WHERE ol.header_id = v_header_id
3452: AND ol.inventory_item_id = msi.inventory_item_id
3453: AND msi.organization_id = nvl(ol.ship_from_org_id,