VIEW: APPS.ZPB_OS_TABLES_V

Source

View Text - Preformatted

SELECT tab.table_id, tab.table_name, col.column_name, col.column_type from zpb_tables tab, zpb_columns col WHERE tab.table_id = col.table_id and tab.bus_area_id = sys_context('ZPB_CONTEXT', 'business_area_id')

View Text - HTML Formatted

SELECT TAB.TABLE_ID
, TAB.TABLE_NAME
, COL.COLUMN_NAME
, COL.COLUMN_TYPE
FROM ZPB_TABLES TAB
, ZPB_COLUMNS COL
WHERE TAB.TABLE_ID = COL.TABLE_ID
AND TAB.BUS_AREA_ID = SYS_CONTEXT('ZPB_CONTEXT'
, 'BUSINESS_AREA_ID')