eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSC_ENTITY_TABLE_MAP_V

Source

View Text - Preformatted


SELECT lookup_code, lookup_type, attribute10 table_name, attribute1 Entity_no, attribute2 Entity_name, attribute3 Where_clause, attribute4 local_id_table, attribute5 local_id_entity, attribute6 instance_id, attribute7 plan_id, attribute8 global, attribute9 delete_flag, attribute11 leg_entity_name, attribute12 leg_entity_no FROM FND_LOOKUP_VALUES flv WHERE flv.lookup_type = 'MSC_ENTITY_TABLE_MAP' AND flv.enabled_flag = 'Y' AND flv.view_application_id = 700 AND flv.language = userenv('lang')

View Text - HTML Formatted

SELECT LOOKUP_CODE
, LOOKUP_TYPE
, ATTRIBUTE10 TABLE_NAME
, ATTRIBUTE1 ENTITY_NO
, ATTRIBUTE2 ENTITY_NAME
, ATTRIBUTE3 WHERE_CLAUSE
, ATTRIBUTE4 LOCAL_ID_TABLE
, ATTRIBUTE5 LOCAL_ID_ENTITY
, ATTRIBUTE6 INSTANCE_ID
, ATTRIBUTE7 PLAN_ID
, ATTRIBUTE8 GLOBAL
, ATTRIBUTE9 DELETE_FLAG
, ATTRIBUTE11 LEG_ENTITY_NAME
, ATTRIBUTE12 LEG_ENTITY_NO
FROM FND_LOOKUP_VALUES FLV
WHERE FLV.LOOKUP_TYPE = 'MSC_ENTITY_TABLE_MAP'
AND FLV.ENABLED_FLAG = 'Y'
AND FLV.VIEW_APPLICATION_ID = 700
AND FLV.LANGUAGE = USERENV('LANG')