FND Design Data [Home] [Help]

View: AX_COLUMNS_V

Product: AX - Global Accounting Engine
Description: Use by the Setup Query Chains form
Implementation/DBA Data: Not implemented in this database
View Text

SELECT FT.APPLICATION_ID APPLICATION_ID
, FT.TABLE_NAME TABLE_NAME
, FC.COLUMN_NAME COLUMN_NAME
, 'T' TYPE
FROM FND_COLUMNS FC
, FND_TABLES FT
WHERE FT.APPLICATION_ID = FC.APPLICATION_ID
AND FT.TABLE_ID = FC.TABLE_ID UNION SELECT FT.APPLICATION_ID APPLICATION_ID
, FT.VIEW_NAME TABLE_NAME
, FC.COLUMN_NAME COLUMN_NAME
, 'V' TYPE
FROM FND_VIEW_COLUMNS FC
, FND_VIEWS FT
WHERE FT.APPLICATION_ID = FC.APPLICATION_ID
AND FT.VIEW_ID = FC.VIEW_ID

Columns

Name
APPLICATION_ID
TABLE_NAME
COLUMN_NAME
TYPE