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
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
Is soa a part of oracle fusion middleware?
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.
please send me forms, xml pulisher questions,answers
Can we create tables in apps schema?
What are the Standard Reports and Forms in HRMS?
Can you differentiate between mediator and osb?
what are the prerequisites for costing transactions?
How do you register report in oracle apps?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Do you know what are user profiles in apps. Any examples you can give?
Which oracle apps version you are very confident in?
Explain what are the tables of auto invoice?
tell me the scenarios of the independent in reports