eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_WF_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 46: oe_order_headers_all header

42: CURSOR find_hdrprocessname (itemkey VARCHAR2)
43: IS
44: SELECT wf_assign.process_name
45: FROM oe_workflow_assignments wf_assign,
46: oe_order_headers_all header
47: WHERE header.header_id = TO_NUMBER (itemkey)
48: AND header.order_type_id = wf_assign.order_type_id
49: AND SYSDATE >= wf_assign.start_date_active
50: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)

Line 60: oe_order_headers_all header

56: CURSOR find_lineprocessname
57: IS
58: SELECT wf_assign.process_name
59: FROM oe_workflow_assignments wf_assign,
60: oe_order_headers_all header
61: WHERE NVL (p_wfasgn_item_type, '-99') =
62: NVL (wf_assign.item_type_code,
63: NVL (p_wfasgn_item_type, '-99')
64: )

Line 77: oe_order_headers_all header

73: CURSOR find_negotiatehdrprocessname (itemkey VARCHAR2)
74: IS
75: SELECT wf_assign.process_name
76: FROM oe_workflow_assignments wf_assign,
77: oe_order_headers_all header
78: WHERE header.header_id = TO_NUMBER (itemkey)
79: AND header.order_type_id = wf_assign.order_type_id
80: AND SYSDATE >= wf_assign.start_date_active
81: AND TRUNC (SYSDATE) <= NVL (wf_assign.end_date_active, SYSDATE)

Line 288: FROM oe_order_headers_all

284: END IF;
285:
286: SELECT org_id
287: INTO l_org_id
288: FROM oe_order_headers_all
289: WHERE header_id = l_header_id;
290:
291: mo_global.set_policy_context ('S', l_org_id);
292:

Line 311: FROM oe_order_headers_all

307:
308: -- ame er 16084377 END
309: SELECT order_number, order_type_id, order_category_code
310: INTO l_order_number, l_order_type_id, l_order_category_code
311: FROM oe_order_headers_all
312: WHERE header_id = l_header_id;
313:
314: SELECT t.NAME
315: INTO l_order_type_name

Line 407: FROM oe_order_headers_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
407: FROM oe_order_headers_all
408: WHERE header_id = l_header_id;
409:
410: SELECT t.NAME
411: INTO l_order_type_name

Line 1196: FROM oe_order_headers_all

1192: -- The create of the header could have been rolled back
1193: -- but the PL/SQL global is not in synch.
1194: SELECT order_type_id
1195: INTO l_type_id
1196: FROM oe_order_headers_all
1197: WHERE header_id = oe_globals.g_start_header_flow;
1198:
1199: IF l_debug_level > 0
1200: THEN

Line 1343: FROM oe_order_headers_all

1339: IF oe_globals.g_sales_document_type_code = 'O'
1340: THEN
1341: SELECT header_id
1342: INTO l_header_id
1343: FROM oe_order_headers_all
1344: WHERE header_id = oe_globals.g_start_negotiate_header_flow;
1345: ELSIF oe_globals.g_sales_document_type_code = 'B'
1346: THEN
1347: SELECT header_id

Line 1839: UPDATE oe_order_headers_all

1835: p_source_document_line_id => NULL
1836: );
1837: l_old_header_rec := l_header_rec;
1838:
1839: UPDATE oe_order_headers_all
1840: SET flow_status_code = p_flow_status_code
1841: --Bug 8435596
1842: ,
1843: last_update_date = SYSDATE,

Line 2476: UPDATE oe_order_headers_all

2472: END IF;
2473: -- GENESIS --
2474: ELSIF p_header_id IS NOT NULL
2475: THEN
2476: UPDATE oe_order_headers_all
2477: SET flow_status_code = p_flow_status_code
2478: --Bug 8435596
2479: ,
2480: last_update_date = SYSDATE,

Line 2791: FROM oe_order_headers_all

2787: IF itemtype = 'OEOH'
2788: THEN
2789: SELECT created_by
2790: INTO v_id
2791: FROM oe_order_headers_all
2792: WHERE header_id = TO_NUMBER (itemkey);
2793: ELSIF itemtype = 'OEOL'
2794: THEN
2795: SELECT header_id

Line 2802: FROM oe_order_headers_all

2798: WHERE line_id = TO_NUMBER (itemkey);
2799:
2800: SELECT created_by
2801: INTO v_id
2802: FROM oe_order_headers_all
2803: WHERE header_id = v_header_id;
2804: END IF;
2805:
2806: SELECT user_name

Line 2820: FROM OE_ORDER_HEADERS_ALL

2816:
2817: ELSIF l_type = 'ORDER_SALESPERSON' THEN
2818: SELECT SALESREP_ID
2819: INTO v_id
2820: FROM OE_ORDER_HEADERS_ALL
2821: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2822: */
2823: ELSIF l_type = 'CREATED_BY'
2824: THEN

Line 2829: FROM oe_order_headers_all

2825: IF itemtype = 'OEOH'
2826: THEN
2827: SELECT created_by
2828: INTO v_id
2829: FROM oe_order_headers_all
2830: WHERE header_id = TO_NUMBER (itemkey);
2831: ELSIF itemtype = 'OEOL'
2832: THEN
2833: SELECT created_by

Line 2853: FROM OE_ORDER_HEADERS_ALL

2849: ELSIF l_type = 'SALESPERSON' THEN
2850: IF itemtype='OEOH' THEN
2851: SELECT SALESREP_ID
2852: INTO v_id
2853: FROM OE_ORDER_HEADERS_ALL
2854: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2855: ELSIF itemtype='OEOL' THEN
2856: SELECT SALESREP_ID
2857: INTO v_id

Line 2998: UPDATE oe_order_headers_all

2994: l_old_header_rec := l_header_rec;
2995:
2996: IF p_flow_status_code IS NOT NULL
2997: THEN
2998: UPDATE oe_order_headers_all
2999: SET flow_status_code = p_flow_status_code
3000: --Bug 8435596
3001: ,
3002: last_update_date = SYSDATE,

Line 3035: UPDATE oe_order_headers_all

3031: END IF;
3032:
3033: IF p_open_flag IS NOT NULL
3034: THEN
3035: UPDATE oe_order_headers_all
3036: SET open_flag = p_open_flag,
3037: -- Bug 12849250
3038: last_update_date = SYSDATE,
3039: last_updated_by = fnd_global.user_id,

Line 3059: UPDATE oe_order_headers_all

3055: END IF;
3056:
3057: IF p_draft_submitted_flag IS NOT NULL
3058: THEN
3059: UPDATE oe_order_headers_all
3060: SET draft_submitted_flag = p_draft_submitted_flag,
3061: -- Bug 12849250
3062: last_update_date = SYSDATE,
3063: last_updated_by = fnd_global.user_id,

Line 3073: UPDATE oe_order_headers_all

3069: END IF;
3070:
3071: IF l_updated_flag = 'Y'
3072: THEN
3073: UPDATE oe_order_headers_all
3074: SET lock_control = lock_control + 1
3075: WHERE header_id = l_header_id;
3076:
3077: l_header_rec.lock_control := l_header_rec.lock_control + 1;

Line 4388: FROM oe_order_headers_all

4384: l_transaction_id := TO_NUMBER (p_item_key);
4385:
4386: SELECT org_id
4387: INTO l_org_id
4388: FROM oe_order_headers_all
4389: WHERE header_id = l_transaction_id;
4390:
4391: mo_global.set_policy_context ('S', l_org_id);
4392:

Line 4452: FROM oe_order_headers_all headers,

4448: NAME,
4449: headers.transactional_curr_code, terms.NAME
4450: INTO l_creation_date, l_ship_to_address, l_invoice_to_address,
4451: l_transactional_curr_code, l_payment_term
4452: FROM oe_order_headers_all headers,
4453: oe_ship_to_orgs_v shipto,
4454: hz_cust_site_uses_all invoiceto,
4455: ra_terms terms
4456: WHERE headers.header_id = l_transaction_id