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_PURGE_PVT dependencies on OE_ORDER_HEADERS

Line 204: FROM OE_ORDER_HEADERS_ALL OOH,

200: OOH.PRICE_LIST_ID,
201: OOH.QUOTE_NUMBER,
202: OOH.FLOW_STATUS_CODE,
203: OOH.UPGRADED_FLAG
204: FROM OE_ORDER_HEADERS_ALL OOH,
205: OE_ORDER_TYPES_V OOT --MOAC view based on multiple obj
206: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
207: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')<>''N''';
208:

Line 698: FROM OE_ORDER_HEADERS_ALL OOH,

694: OOH.PRICE_LIST_ID,
695: OOH.EXPIRATION_DATE,
696: OOH.FLOW_STATUS_CODE,
697: OOH.UPGRADED_FLAG
698: FROM OE_ORDER_HEADERS_ALL OOH,
699: OE_ORDER_TYPES_V OOT --MOAC view based on multiple objects
700: WHERE OOH.ORDER_TYPE_ID = OOT.ORDER_TYPE_ID
701: AND NVL(OOH.TRANSACTION_PHASE_CODE,''F'')=''N''';
702:

Line 1119: oe_order_headers_all ooh

1115: , l_flow_status_code
1116: , l_upgraded_flag
1117: , l_transaction_phase_code
1118: From oe_order_types_v oot, --MOAC view based on multiple objects
1119: oe_order_headers_all ooh
1120:
1121: WHERE
1122: ooh.header_id = l_header_id
1123: AND ooh.order_type_id = oot.order_type_id;

Line 1326: FROM oe_order_headers

1322: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Check_And_Get_Detail : '||to_char(p_order_number));
1323: --Quote purge changes.To Select Transaction Phase code
1324: SELECT transaction_phase_code
1325: INTO l_transaction_phase_code
1326: FROM oe_order_headers
1327: WHERE header_id=p_header_id;
1328:
1329: IF p_flow_status_code IS NOT NULL THEN
1330: SELECT meaning

Line 1371: oe_order_headers ooh

1367:
1368: SELECT otl.name
1369: INTO l_order_type_name
1370: FROM oe_transaction_types_tl otl,
1371: oe_order_headers ooh
1372: WHERE otl.language = (select language_code
1373: from fnd_languages
1374: where installed_flag = 'B')
1375: AND otl.transaction_type_id = ooh.order_type_id

Line 1807: FROM OE_ORDER_HEADERS

1803: RETURN VARCHAR2
1804: IS
1805: CURSOR c_open_quotes IS
1806: SELECT 'Open Quotes'
1807: FROM OE_ORDER_HEADERS
1808: WHERE HEADER_ID = p_header_id
1809: AND NVL(OPEN_FLAG,'Y') = 'N';
1810:
1811: l_open_quotes VARCHAR2(50);

Line 1839: FROM OE_ORDER_HEADERS

1835: RETURN VARCHAR2
1836: IS
1837: CURSOR c_open_orders IS
1838: SELECT 'Open Orders'
1839: FROM OE_ORDER_HEADERS
1840: WHERE Header_id=p_header_id --for Bug # 4516769
1841: AND NVL(OPEN_FLAG,'Y') = 'N';
1842:
1843: l_open_orders VARCHAR2(50);

Line 1917: oe_order_headers_all sh,

1913: --FROM oe_order_lines sl1,
1914: --oe_order_lines sl2,
1915: FROM oe_order_lines_all sl1,
1916: oe_order_lines_all sl2,
1917: oe_order_headers_all sh,
1918: oe_order_types_v ot --MOAC view based on multiple objects
1919: WHERE sh.order_number = p_order_number
1920: AND sh.order_type_id = ot.order_type_id
1921: AND ot.name = p_order_type_name

Line 2141: FROM oe_order_headers

2137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2138: l_error_msg VARCHAR2(240);
2139: CURSOR c_lock_header IS
2140: SELECT header_id -- Lock all rows to be purged
2141: FROM oe_order_headers
2142: WHERE header_id = p_header_id
2143: FOR UPDATE NOWAIT;
2144:
2145: CURSOR c_lock_header_hist IS

Line 2167: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id)

2163: --16193599 Audit History Purge Start
2164: CURSOR c_lock_audit_hist_ent1 IS
2165: SELECT entity_id -- Lock all rows to be purged
2166: FROM OE_AUDIT_ATTR_HISTORY
2167: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id)
2168: FOR UPDATE NOWAIT;
2169:
2170: CURSOR c_lock_audit_hist_ent2 IS
2171: SELECT entity_id -- Lock all rows to be purged

Line 2208: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id);

2204: OPEN c_lock_audit_hist_ent1;
2205: CLOSE c_lock_audit_hist_ent1;
2206: DELETE
2207: FROM OE_AUDIT_ATTR_HISTORY
2208: WHERE (entity_id,entity_number) IN (SELECT 1,header_id FROM oe_order_headers_all WHERE header_id=p_header_id);
2209:
2210: OPEN c_lock_audit_hist_ent2;
2211: CLOSE c_lock_audit_hist_ent2;
2212: DELETE

Line 2421: DELETE FROM oe_order_headers

2417:
2418: END IF;
2419:
2420: END IF;
2421: DELETE FROM oe_order_headers
2422: WHERE header_id = p_header_id;
2423: oe_debug_pub.add('deleted header='|| to_char(p_header_id));
2424:
2425: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Headers : ');

Line 2438: ,'ORDPUR: OE_ORDER_HEADERS '||substr(sqlerrm,1,200)

2434: ROLLBACK TO SAVEPOINT ORDER_HEADER;
2435: record_errors( l_return_status
2436: ,p_purge_set_id
2437: ,p_header_id
2438: ,'ORDPUR: OE_ORDER_HEADERS '||substr(sqlerrm,1,200)
2439: );
2440: CLOSE c_lock_header;
2441:
2442: END Oe_Purge_Headers;

Line 3723: FROM oe_order_headers

3719: l_cnt NUMBER;
3720:
3721: CURSOR cur_transaction_code IS
3722: SELECT transaction_phase_code
3723: FROM oe_order_headers
3724: WHERE header_id=p_header_id;
3725:
3726: BEGIN
3727:

Line 3790: oe_order_headers ooh

3786:
3787: SELECT otl.name
3788: INTO l_order_type_name
3789: FROM oe_transaction_types_tl otl,
3790: oe_order_headers ooh
3791: WHERE otl.language = (SELECT language_code
3792: FROM fnd_languages
3793: WHERE installed_flag = 'B')
3794: AND otl.transaction_type_id = ooh.order_type_id