What is the difference between _all, _tl, _vl, _v tables in Oracle Apps?
Submitted by: Administrator_all : Table holds all the information about different operating units. Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
_TL : Translation Tables. where we can find the name of the particular field we are referring to. All _TL tables has a unique ID which corresponds the foreign key to other table which is used to store in the database and referenced back to display the name.
_V: are views.
_vl table stores the MultiLingual views
Submitted by: Administrator
_TL : Translation Tables. where we can find the name of the particular field we are referring to. All _TL tables has a unique ID which corresponds the foreign key to other table which is used to store in the database and referenced back to display the name.
_V: are views.
_vl table stores the MultiLingual views
Submitted by: Administrator
Read Online Oracle AR Job Interview Questions And Answers
Top Oracle AR Questions
| ☺ | Explain Accounting for invoice in Advance and Arrears? |
| ☺ | What is the difference between _all, _tl, _vl, _v tables in Oracle Apps? |
| ☺ | What do you mean by HZ_ in customer tables? |
| ☺ | How is the balance of an invoice derived? |
| ☺ | What are Different types of transactions in AR? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
