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 2367: DELETE FROM oe_order_headers

2363:
2364: END IF;
2365:
2366: END IF;
2367: DELETE FROM oe_order_headers
2368: WHERE header_id = p_header_id;
2369: oe_debug_pub.add('deleted header='|| to_char(p_header_id));
2370:
2371: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Headers : ');

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

2380: ROLLBACK TO SAVEPOINT ORDER_HEADER;
2381: record_errors( l_return_status
2382: ,p_purge_set_id
2383: ,p_header_id
2384: ,'ORDPUR: OE_ORDER_HEADERS '||substr(sqlerrm,1,200)
2385: );
2386: CLOSE c_lock_header;
2387:
2388: END Oe_Purge_Headers;

Line 3669: FROM oe_order_headers

3665: l_cnt NUMBER;
3666:
3667: CURSOR cur_transaction_code IS
3668: SELECT transaction_phase_code
3669: FROM oe_order_headers
3670: WHERE header_id=p_header_id;
3671:
3672: BEGIN
3673:

Line 3736: oe_order_headers ooh

3732:
3733: SELECT otl.name
3734: INTO l_order_type_name
3735: FROM oe_transaction_types_tl otl,
3736: oe_order_headers ooh
3737: WHERE otl.language = (SELECT language_code
3738: FROM fnd_languages
3739: WHERE installed_flag = 'B')
3740: AND otl.transaction_type_id = ooh.order_type_id