Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

Answer Posted / viswa

view is one of the object, it is like as a table ,it will
created based on table,it has no data,using this we can
retrieve particular organization information

syntax
create view<view name> as select *from <table name> where
org_id=userenv('client_info')

Is This Answer Correct ?    6 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?

3065


Is soa a part of oracle fusion middleware?

1090


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

3035


please send me forms, xml pulisher questions,answers

2113


Can we create tables in apps schema?

1143


What are the Standard Reports and Forms in HRMS?

2320


Can you differentiate between mediator and osb?

1144


what are the prerequisites for costing transactions?

3144


How do you register report in oracle apps?

1099


List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2219


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2389


Do you know what are user profiles in apps. Any examples you can give?

1097


Which oracle apps version you are very confident in?

1214


Explain what are the tables of auto invoice?

1142


tell me the scenarios of the independent in reports

2626