DBA Data[Home] [Help]

VIEW: APPS.MSC_PDSONLY_TABLE_V

Source

View Text - Preformatted

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

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