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 43: oe_order_headers_all header

39:
40: CURSOR find_HdrProcessname(itemkey varchar2) is
41: select wf_assign.process_name
42: from oe_workflow_assignments wf_assign,
43: oe_order_headers_all header
44: where header.header_id = to_number(itemkey)
45: and header.order_type_id = wf_assign.order_type_id
46: and sysdate >= wf_assign.start_date_active
47: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)

Line 55: oe_order_headers_all header

51:
52: CURSOR find_LineProcessname is
53: SELECT wf_assign.process_name
54: FROM oe_workflow_assignments wf_assign,
55: oe_order_headers_all header
56: WHERE nvl(p_wfasgn_item_type,'-99') =
57: nvl(wf_assign.item_type_code,nvl(p_wfasgn_item_type,'-99'))
58: AND header.header_id = p_line_rec.header_id AND
59: header.order_type_id = wf_assign.order_type_id

Line 69: oe_order_headers_all header

65:
66: CURSOR find_NegotiateHdrProcessname(itemkey varchar2) is
67: SELECT wf_assign.process_name
68: FROM oe_workflow_assignments wf_assign,
69: oe_order_headers_all header
70: WHERE header.header_id = to_number(itemkey)
71: and header.order_type_id = wf_assign.order_type_id
72: and sysdate >= wf_assign.start_date_active
73: and trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate)

Line 216: from oe_order_headers_all

212: END;
213:
214: SELECT order_number, order_type_id, order_category_code
215: into l_order_number, l_order_type_id, l_order_category_code
216: from oe_order_headers_all
217: where header_id = l_header_id;
218:
219: SELECT T.NAME
220: INTO l_order_type_name

Line 297: from oe_order_headers_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
297: from oe_order_headers_all
298: where header_id = l_header_id;
299:
300: SELECT T.NAME
301: INTO l_order_type_name

Line 1091: from oe_order_headers_all

1087: -- The create of the header could have been rolled back
1088: -- but the PL/SQL global is not in synch.
1089: Select order_type_id
1090: into l_type_id
1091: from oe_order_headers_all
1092: where header_id = OE_GLOBALS.G_START_HEADER_FLOW;
1093:
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add( 'STARTING HEADER FLOW' ) ;

Line 1210: from oe_order_headers_all

1206: -- but the PL/SQL global is not in synch.
1207: IF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'O' THEN
1208: Select header_id
1209: into l_header_id
1210: from oe_order_headers_all
1211: where header_id = OE_GLOBALS.G_START_NEGOTIATE_HEADER_FLOW;
1212: ELSIF OE_GLOBALS.G_SALES_DOCUMENT_TYPE_CODE = 'B' THEN
1213: Select header_id
1214: into l_header_id

Line 1565: UPDATE OE_ORDER_HEADERS_ALL

1561: ,p_source_document_line_id => null );
1562:
1563: l_old_header_rec := l_header_rec;
1564:
1565: UPDATE OE_ORDER_HEADERS_ALL
1566: SET FLOW_STATUS_CODE = p_flow_status_code
1567: , LOCK_CONTROL = LOCK_CONTROL + 1
1568: WHERE HEADER_ID = p_header_id;
1569:

Line 2006: UPDATE OE_ORDER_HEADERS_ALL

2002: -- GENESIS --
2003:
2004: ELSIF p_header_id IS NOT NULL THEN
2005:
2006: UPDATE OE_ORDER_HEADERS_ALL
2007: SET FLOW_STATUS_CODE = p_flow_status_code
2008: , LOCK_CONTROL = LOCK_CONTROL + 1
2009: WHERE HEADER_ID = p_header_id;
2010:

Line 2204: FROM OE_ORDER_HEADERS_ALL

2200: ELSIF l_type = 'ORDER_CREATED_BY' THEN
2201: IF itemtype = 'OEOH' THEN
2202: SELECT CREATED_BY
2203: INTO v_id
2204: FROM OE_ORDER_HEADERS_ALL
2205: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2206: ELSIF itemtype = 'OEOL' THEN
2207: SELECT HEADER_ID
2208: INTO v_header_id

Line 2214: FROM OE_ORDER_HEADERS_ALL

2210: WHERE LINE_ID = TO_NUMBER(ITEMKEY);
2211:
2212: SELECT CREATED_BY
2213: INTO v_id
2214: FROM OE_ORDER_HEADERS_ALL
2215: WHERE HEADER_ID = v_header_id;
2216: END IF;
2217: SELECT USER_NAME
2218: INTO v_value

Line 2232: FROM OE_ORDER_HEADERS_ALL

2228:
2229: ELSIF l_type = 'ORDER_SALESPERSON' THEN
2230: SELECT SALESREP_ID
2231: INTO v_id
2232: FROM OE_ORDER_HEADERS_ALL
2233: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2234: */
2235: ELSIF l_type = 'CREATED_BY' THEN
2236: IF itemtype='OEOH' THEN

Line 2239: FROM OE_ORDER_HEADERS_ALL

2235: ELSIF l_type = 'CREATED_BY' THEN
2236: IF itemtype='OEOH' THEN
2237: SELECT CREATED_BY
2238: INTO v_id
2239: FROM OE_ORDER_HEADERS_ALL
2240: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2241: ELSIF itemtype='OEOL' THEN
2242: SELECT CREATED_BY
2243: INTO v_id

Line 2263: FROM OE_ORDER_HEADERS_ALL

2259: ELSIF l_type = 'SALESPERSON' THEN
2260: IF itemtype='OEOH' THEN
2261: SELECT SALESREP_ID
2262: INTO v_id
2263: FROM OE_ORDER_HEADERS_ALL
2264: WHERE HEADER_ID = TO_NUMBER(ITEMKEY);
2265: ELSIF itemtype='OEOL' THEN
2266: SELECT SALESREP_ID
2267: INTO v_id

Line 2379: UPDATE OE_ORDER_HEADERS_ALL

2375:
2376: l_old_header_rec := l_header_rec;
2377:
2378: IF p_flow_status_code is not null THEN
2379: UPDATE OE_ORDER_HEADERS_ALL
2380: SET FLOW_STATUS_CODE = p_flow_status_code
2381: WHERE HEADER_ID = l_header_id;
2382:
2383: -- Also update all lines to have the same flow_status_code

Line 2401: UPDATE OE_ORDER_HEADERS_ALL

2397: l_header_rec.flow_status_code := p_flow_status_code;
2398: END IF;
2399:
2400: IF p_open_flag is not null THEN
2401: UPDATE OE_ORDER_HEADERS_ALL
2402: SET OPEN_FLAG = p_open_flag
2403: WHERE HEADER_ID = l_header_id;
2404:
2405: l_updated_flag := 'Y';

Line 2417: UPDATE OE_ORDER_HEADERS_ALL

2413:
2414: END IF;
2415:
2416: IF p_draft_submitted_flag is not null THEN
2417: UPDATE OE_ORDER_HEADERS_ALL
2418: SET DRAFT_SUBMITTED_FLAG = p_draft_submitted_flag
2419: WHERE HEADER_ID = l_header_id;
2420:
2421: l_updated_flag := 'Y';

Line 2426: UPDATE OE_ORDER_HEADERS_ALL

2422: l_header_rec.draft_submitted_flag := p_draft_submitted_flag;
2423: END IF;
2424:
2425: IF l_updated_flag = 'Y' THEN
2426: UPDATE OE_ORDER_HEADERS_ALL
2427: SET LOCK_CONTROL = LOCK_CONTROL + 1
2428: WHERE HEADER_ID = l_header_id;
2429:
2430: l_header_rec.lock_control := l_header_rec.lock_control + 1;

Line 3463: select org_id into l_org_id from oe_order_headers_all where header_id = l_transaction_id;

3459:
3460: BEGIN
3461:
3462: l_transaction_id := to_number(p_item_key);
3463: select org_id into l_org_id from oe_order_headers_all where header_id = l_transaction_id;
3464: MO_GLOBAL.set_policy_context('S', l_org_id);
3465:
3466: -- Bug 6275663
3467: IF ( nvl(Oe_Order_Util.G_Precision,0) = 0 ) THEN

Line 3511: FROM oe_order_headers_all headers,

3507: invoiceto.LOCATION name,
3508: headers.TRANSACTIONAL_CURR_CODE, terms.NAME
3509: INTO l_creation_date, l_ship_to_address, l_invoice_to_address,
3510: l_transactional_curr_code, l_payment_term
3511: FROM oe_order_headers_all headers,
3512: oe_ship_to_orgs_v shipto,
3513: HZ_CUST_SITE_USES_ALL invoiceto,
3514: ra_terms terms
3515: where headers.header_id = l_transaction_id