Require SQL statement to display 1. View_name 2. view_column and 3. corresponding line of view defin
This is a SQL language question that arose out of investigating Sub Ledger Accounting (SLA)
The source objects are defined from Transaction Objects (which are in fact SQL views on the Transaction Information required by SLA).
The default source object name is the view column name.
HOWEVER, in SQL I would like to display the SQL select clause that corresponds to the view column so I can identify exactly (from the SQL) what the source object represents.
THEREFORE, I would like to write a SQL query that gives me the following columns
1. VIEW_NAME
2. VIEW_COLUMN_NAME
3. SQL that matches the VIEW_COLUMN_NAME
The source objects are defined from Transaction Objects (which are in fact SQL views on the Transaction Information required by SLA).
The default source object name is the view column name.
HOWEVER, in SQL I would like to display the SQL select clause that corresponds to the view column so I can identify exactly (from the SQL) what the source object represents.
THEREFORE, I would like to write a SQL query that gives me the following columns
1. VIEW_NAME
2. VIEW_COLUMN_NAME
3. SQL that matches the VIEW_COLUMN_NAME
0