What is the significance of _ALL suffix in oracle tables?

Oracle Apps Interview Questions › Category: AOL-SysAdmin › What is the significance of _ALL suffix in oracle tables?
0 Vote Up Vote Down
Questions Master asked 10 years ago

does only tables have _ALL or any other objects have _ALL as suffix?

1 Answers
0 Vote Up Vote Down
Shailender Thallam Staff answered 10 years ago

_ALL  Table holds all the information about different operating units in a Multi-Org environment. You can also set the client_info to specific operating unit to see the data specific to that operating unit only.
Check out the article -> MOAC – Oracle Apps ORG_ID, Multi Org Concept