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
How to move the one file from one instance to another instance? And your scripts also?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Which oracle apps version you are very confident in?
what is the differences between internal requisition and internal sales order?
what are the balancing segments in AR?
How is choreography different from orchestration?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
how can develope the po variance and po summary report? with tables mandatory columns and query please?
Explain what are the tables of auto invoice?
How can a process be deployed in soa?
Tell me how to find the custom directory in front end?
What are the different components of soa suite?
what is pay run id ?
List the various types of value set.
What are the Standard Reports and Forms in HRMS?