OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » 'ONT' Schema

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

'ONT' Schema [message #147872]

Mon, 21 November 2005 08:09

Welzorg Administrator
Messages: 3
Registered: November 2005
Location: Amsterdam / Netherlands

Junior Member

Can somebody tell me where 'ONT' (schema) stands for?

Report message to a moderator

Re: 'ONT' Schema [message #147874 is a reply to message #147872]

Mon, 21 November 2005 08:39

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

ONT is the product short name for Order Management.

You could have found this out yourself by using the Application form in the Application Developer responsibility or by querying the FND_APPLICATION table as follows:

SELECT fat.application_name
  FROM fnd_application fa
  JOIN fnd_application_tl fat
    ON fa.application_id = fat.application_id
 WHERE fa.application_short_name = 'ONT'

--
Aleksander Dragnes

Report message to a moderator

Re: 'ONT' Schema [message #147889 is a reply to message #147874]

Mon, 21 November 2005 09:44

Welzorg Administrator
Messages: 3
Registered: November 2005
Location: Amsterdam / Netherlands

Junior Member

Aleksander,

Thanks for the speedy reply.
You're right.

The query you send me I had to adjust otherwise I couldn't run it thru TOAD:

SELECT fat.application_name
FROM fnd_application fa
, fnd_application_tl fat
WHERE fa.application_id = fat.application_id
AND fa.application_short_name = 'ONT'

Again THX.

Rob

Report message to a moderator

Re: 'ONT' Schema [message #147900 is a reply to message #147872]

Mon, 21 November 2005 10:39

sambireddyn
Messages: 48
Registered: May 2005
Location: Andhra Pradesh

Member

Hi

What is the full form of ONT?

Regards,
SambiReddy.

Report message to a moderator

Re: 'ONT' Schema [message #147985 is a reply to message #147889]

Tue, 22 November 2005 02:03

adragnes
Messages: 241
Registered: February 2005
Location: Oslo, Norway

Senior Member

Welzorg Administrator wrote on Mon, 21 November 2005 16:44

The query you send me I had to adjust otherwise I couldn't run it thru TOAD

Still using Oracle 8i? I think it is time to plan for an upgrade.. Wink

--
Aleksander Dragnes

Report message to a moderator

Re: 'ONT' Schema [message #148022 is a reply to message #147872]

Tue, 22 November 2005 05:42

Welzorg Administrator
Messages: 3
Registered: November 2005
Location: Amsterdam / Netherlands

Junior Member

W're planning the updrage right now. Going to database release 9.2.0.6
Didn't know the sql statement you send me works on 9i.

THX.

Report message to a moderator

Previous Topic:	Records Stuck in rcv_headers_interface during ASN creation
Next Topic:	Oracle Applications 11i financials functional interview questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 09 02:40:17 CDT 2024