VIEW: APPS.FEM_FACTOR_TABLE_DIMS_V

Source

View Text - Preformatted

SELECT O.OBJECT_ID,D.LEVEL_NUM,D.DIMENSION_ID,D.DIM_USAGE_CODE,D.FORCE_PERCENT_FLAG FROM FEM_FACTOR_TABLES F,FEM_FACTOR_TABLE_DIMS D,FEM_OBJECT_DEFINITION_VL O WHERE F.object_definition_id = D.object_definition_id AND F.object_definition_id = O.object_definition_id and O.object_definition_id = (select min(B.object_definition_id) from fem_object_definition_b B where B.object_id = O.object_id)

View Text - HTML Formatted

SELECT O.OBJECT_ID
, D.LEVEL_NUM
, D.DIMENSION_ID
, D.DIM_USAGE_CODE
, D.FORCE_PERCENT_FLAG
FROM FEM_FACTOR_TABLES F
, FEM_FACTOR_TABLE_DIMS D
, FEM_OBJECT_DEFINITION_VL O
WHERE F.OBJECT_DEFINITION_ID = D.OBJECT_DEFINITION_ID
AND F.OBJECT_DEFINITION_ID = O.OBJECT_DEFINITION_ID
AND O.OBJECT_DEFINITION_ID = (SELECT MIN(B.OBJECT_DEFINITION_ID)
FROM FEM_OBJECT_DEFINITION_B B
WHERE B.OBJECT_ID = O.OBJECT_ID)