FLA_PROPERTY_TYPES_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name
PROPERTY_TYPE_ID ORG_ID PROPERTY_TYPE_CODE PROPERTY_TYPE_MEANING ACTIVE_FLAG PROPERTY_TYPE_LEVEL_CODE PROPERTY_LEVEL_MEANING PROPERTY_TYPE_LEVEL_NUM LEASABLE_LEVEL_FLAG UNIT_OF_MEASURE_CODE PREV_PROPERTY_LEVEL_CODE PREV_PROPERTY_LEVEL_MEANING NEXT_PROPERTY_LEVEL_CODE NEXT_PROPERTY_LEVEL_MEANING

Query

SQL_Statement

SELECT pt.property_type_id, pt.org_id, pt.property_type_code, tl.meaning property_type_meaning, pt.active_flag, ptl.property_type_level_code, ll.meaning property_level_meaning, ptl.property_type_level_num, ptl.leasable_level_flag, ptl.unit_of_measure_code, LAG(ptl.property_type_level_code) OVER (PARTITION BY pt.property_type_id ORDER BY ptl.property_type_level_num) prev_property_level_code, LAG(ll.meaning) OVER (PARTITION BY pt.property_type_id ORDER BY ptl.property_type_level_num) prev_property_level_meaning, LEAD(ptl.property_type_level_code) OVER (PARTITION BY pt.property_type_id ORDER BY ptl.property_type_level_num) next_property_level_code, LEAD(ll.meaning) OVER (PARTITION BY pt.property_type_id ORDER BY ptl.property_type_level_num) next_property_level_meaning FROM fla_property_types_all pt, fla_property_type_levels ptl, fnd_lookups tl, fnd_lookups ll WHERE pt.property_type_id = ptl.property_type_id AND tl.lookup_type(+) = 'ORA_FLA_PROPERTY_TYPE' AND pt.property_type_code = tl.lookup_code(+) AND ll.lookup_type(+) = 'ORA_FLA_PROPERTY_TYPE_LEVEL' AND ptl.property_type_level_code = ll.lookup_code(+)