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_ALL

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 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 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