APPS.OE_ORDER_WF_UTIL dependencies on OE_ORDER_LINES_ALL

Line 402: FROM oe_order_lines_all

398: SELECT header_id, line_number, shipment_number, option_number,
399: service_number
400: INTO l_header_id, l_line_number, l_shipment_number, l_option_number,
401: l_service_number
402: FROM oe_order_lines_all
403: WHERE line_id = l_line_id;
404:
405: SELECT order_number, order_type_id, order_category_code
406: INTO l_order_number, l_order_type_id, l_order_category_code

Line 1259: FROM oe_order_lines_all

1255: SELECT line_type_id, item_type_code, ato_line_id,
1256: line_id
1257: INTO l_type_id, l_item_type_code, l_ato_line_id,
1258: l_line_id
1259: FROM oe_order_lines_all
1260: WHERE line_id =
1261: oe_globals.g_start_line_flows_tbl (ctr).line_id;
1262:
1263: IF l_debug_level > 0

Line 1521: FROM oe_order_lines_all

1517: ELSIF p_type = 'LINE'
1518: THEN
1519: SELECT transaction_phase_code
1520: INTO l_transaction_phase_code
1521: FROM oe_order_lines_all
1522: WHERE line_id = p_id;
1523:
1524: IF NVL (l_transaction_phase_code, 'F') <> 'N'
1525: THEN

Line 1709: FROM oe_order_lines_all

1705:
1706: CURSOR lines
1707: IS
1708: SELECT line_id, lock_control
1709: FROM oe_order_lines_all
1710: WHERE header_id = p_header_id
1711: FOR UPDATE NOWAIT;
1712:
1713: l_line_id NUMBER;

Line 1861: UPDATE oe_order_lines_all

1857: END LOOP;
1858:
1859: CLOSE lines;
1860:
1861: UPDATE oe_order_lines_all
1862: SET flow_status_code = p_flow_status_code
1863: --Bug 8435596
1864: ,
1865: last_update_date = SYSDATE,

Line 2129: FROM oe_order_lines_all

2125: l_header_id, l_orig_sys_document_ref,
2126: l_orig_sys_line_ref, l_order_source_id,
2127: l_orig_sys_shipment_ref, l_change_sequence,
2128: l_source_document_type_id
2129: FROM oe_order_lines_all
2130: WHERE line_id = p_line_id
2131: FOR UPDATE NOWAIT;
2132:
2133: oe_msg_pub.set_msg_context

Line 2194: UPDATE oe_order_lines_all

2190: END IF;
2191:
2192: IF p_line_id IS NOT NULL
2193: THEN
2194: UPDATE oe_order_lines_all
2195: SET flow_status_code = p_flow_status_code,
2196: last_update_date = SYSDATE,
2197: --last_updated_by = FND_GLOBAL.USER_ID,
2198: last_updated_by =

Line 2797: FROM oe_order_lines_all

2793: ELSIF itemtype = 'OEOL'
2794: THEN
2795: SELECT header_id
2796: INTO v_header_id
2797: FROM oe_order_lines_all
2798: WHERE line_id = TO_NUMBER (itemkey);
2799:
2800: SELECT created_by
2801: INTO v_id

Line 2835: FROM oe_order_lines_all

2831: ELSIF itemtype = 'OEOL'
2832: THEN
2833: SELECT created_by
2834: INTO v_id
2835: FROM oe_order_lines_all
2836: WHERE line_id = TO_NUMBER (itemkey);
2837: END IF;
2838:
2839: SELECT user_name

Line 2858: FROM OE_ORDER_LINES_ALL

2854: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2855: ELSIF itemtype='OEOL' THEN
2856: SELECT SALESREP_ID
2857: INTO v_id
2858: FROM OE_ORDER_LINES_ALL
2859: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2860: END IF;
2861: */
2862: END IF;

Line 2913: FROM oe_order_lines_all

2909:
2910: CURSOR lines
2911: IS
2912: SELECT line_id, lock_control
2913: FROM oe_order_lines_all
2914: WHERE header_id = l_header_id
2915: FOR UPDATE NOWAIT;
2916:
2917: CURSOR blanket_lines

Line 3019: UPDATE oe_order_lines_all

3015: END LOOP;
3016:
3017: CLOSE lines;
3018:
3019: UPDATE oe_order_lines_all
3020: SET flow_status_code = p_flow_status_code
3021: --Bug 8435596
3022: ,
3023: last_update_date = SYSDATE,

Line 3047: UPDATE oe_order_lines_all

3043: l_updated_flag := 'Y';
3044: l_header_rec.open_flag := p_open_flag;
3045:
3046: -- XDING bug FP5172433
3047: UPDATE oe_order_lines_all
3048: SET open_flag = p_open_flag,
3049: -- Bug 12849250
3050: last_update_date = SYSDATE,
3051: last_updated_by = fnd_global.user_id,

Line 4367: FROM oe_order_lines_all ol, mtl_system_items_kfv msi

4363: ol.inventory_item_id, ol.item_type_code, ol.open_flag,
4364: ol.shipped_quantity, ol.ordered_quantity,
4365: ol.source_type_code, ol.ship_from_org_id, ol.project_id,
4366: ol.actual_shipment_date, ol.fulfillment_date
4367: FROM oe_order_lines_all ol, mtl_system_items_kfv msi
4368: WHERE ol.header_id = v_header_id
4369: AND ol.inventory_item_id = msi.inventory_item_id
4370: AND msi.organization_id =
4371: NVL