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_AUDIT_HISTORY_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 566: FROM OE_ORDER_HEADERS_ALL

562: /*if order_number_from is not null then
563: BEGIN
564: SELECT HEADER_ID
565: INTO l_header_id_from
566: FROM OE_ORDER_HEADERS_ALL
567: WHERE ORDER_NUMBER = order_number_from;
568: END;
569: end if;
570: if order_number_from is not null then

Line 574: FROM OE_ORDER_HEADERS_ALL

570: if order_number_from is not null then
571: BEGIN
572: SELECT HEADER_ID
573: INTO l_header_id_to
574: FROM OE_ORDER_HEADERS_ALL
575: WHERE ORDER_NUMBER = order_number_to;
576: END;
577: end if;*/
578:

Line 976: FROM OE_ORDER_HEADERS_ALL --bug14285026

972:
973: BEGIN
974: SELECT ORDER_NUMBER,SOLD_TO_ORG_ID,ORDER_TYPE_ID,ORG_ID
975: INTO l_order_number,l_sold_to_org_id,l_order_type_id,l_org_id
976: FROM OE_ORDER_HEADERS_ALL --bug14285026
977: WHERE HEADER_ID = l_header_id;
978:
979: EXCEPTION WHEN OTHERS THEN
980: IF l_debug_level > 0 THEN

Line 1341: --bug14285026 changed oe_order_headers to oe_order_headers_all

1337: if c_attr_tbl(j).attribute_id in (46, 47, 48,49) then
1338:
1339: -- get the instrument id for cc number
1340: -- bug 8586227
1341: --bug14285026 changed oe_order_headers to oe_order_headers_all
1342: l_sql_stmt_txn := 'select itev.instrument_id'||' ,ooh.Context '||
1343: ' from oe_order_headers_all ooh, oe_payments op, IBY_EXTN_INSTR_DETAILS_V itev '||
1344: ' where '||
1345: ' ooh.header_id = :y'||' and ooh.header_id = op.header_id and op.line_id is null and nvl(op.payment_collection_event,''PREPAY'') = ''INVOICE'' and op.trxn_extension_id = itev.trxn_extension_id';

Line 1343: ' from oe_order_headers_all ooh, oe_payments op, IBY_EXTN_INSTR_DETAILS_V itev '||

1339: -- get the instrument id for cc number
1340: -- bug 8586227
1341: --bug14285026 changed oe_order_headers to oe_order_headers_all
1342: l_sql_stmt_txn := 'select itev.instrument_id'||' ,ooh.Context '||
1343: ' from oe_order_headers_all ooh, oe_payments op, IBY_EXTN_INSTR_DETAILS_V itev '||
1344: ' where '||
1345: ' ooh.header_id = :y'||' and ooh.header_id = op.header_id and op.line_id is null and nvl(op.payment_collection_event,''PREPAY'') = ''INVOICE'' and op.trxn_extension_id = itev.trxn_extension_id';
1346: else
1347: --bug14285026 changed oe_order_headers to oe_order_headers_all

Line 1347: --bug14285026 changed oe_order_headers to oe_order_headers_all

1343: ' from oe_order_headers_all ooh, oe_payments op, IBY_EXTN_INSTR_DETAILS_V itev '||
1344: ' where '||
1345: ' ooh.header_id = :y'||' and ooh.header_id = op.header_id and op.line_id is null and nvl(op.payment_collection_event,''PREPAY'') = ''INVOICE'' and op.trxn_extension_id = itev.trxn_extension_id';
1346: else
1347: --bug14285026 changed oe_order_headers to oe_order_headers_all
1348: l_sql_stmt_txn := 'select '||c_attr_tbl(j).column_name||' ,Context '||
1349: ' from oe_order_headers_all '||
1350: ' where '||
1351: ' header_id = :y';

Line 1349: ' from oe_order_headers_all '||

1345: ' ooh.header_id = :y'||' and ooh.header_id = op.header_id and op.line_id is null and nvl(op.payment_collection_event,''PREPAY'') = ''INVOICE'' and op.trxn_extension_id = itev.trxn_extension_id';
1346: else
1347: --bug14285026 changed oe_order_headers to oe_order_headers_all
1348: l_sql_stmt_txn := 'select '||c_attr_tbl(j).column_name||' ,Context '||
1349: ' from oe_order_headers_all '||
1350: ' where '||
1351: ' header_id = :y';
1352: end if;
1353: