DBA Data[Home] [Help]

VIEW: APPS.MSC_STAGING_TABLE_V

Source

View Text - Preformatted

SELECT LOOKUP_TYPE, LOOKUP_CODE, MEANING table_name, description, ATTRIBUTE1 Application_ID, ATTRIBUTE3 logging_clause, ATTRIBUTE4 Deg_of_parall, ATTRIBUTE5 PARTITION_TYPE, ATTRIBUTE6 INITIAL_EXTENT, ATTRIBUTE7 NEXT_EXTENT, ATTRIBUTE8 PCT_Increase, ATTRIBUTE9 PCT_Free, ATTRIBUTE10 PCT_Used FROM FND_LOOKUP_VALUES WHERE lookup_type = 'MSC_STAGING_TABLE' AND enabled_flag = 'Y' AND view_application_id = 700 AND language = userenv('lang')
View Text - HTML Formatted

SELECT LOOKUP_TYPE
, LOOKUP_CODE
, MEANING TABLE_NAME
, DESCRIPTION
, ATTRIBUTE1 APPLICATION_ID
, ATTRIBUTE3 LOGGING_CLAUSE
, ATTRIBUTE4 DEG_OF_PARALL
, ATTRIBUTE5 PARTITION_TYPE
, ATTRIBUTE6 INITIAL_EXTENT
, ATTRIBUTE7 NEXT_EXTENT
, ATTRIBUTE8 PCT_INCREASE
, ATTRIBUTE9 PCT_FREE
, ATTRIBUTE10 PCT_USED
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'MSC_STAGING_TABLE'
AND ENABLED_FLAG = 'Y'
AND VIEW_APPLICATION_ID = 700
AND LANGUAGE = USERENV('LANG')