1. Tables and Views for Financials
  2. FLA_XLA_ASSET_REF_V

FLA_XLA_ASSET_REF_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

LEASE_ASSET_ID

PAYMENT_ASSET_NUMBER

ASSET_LEASE_DETAIL_ID

INVENTORY_ITEM_ID

ITEM_CATEGORY_CODE

ASSET_MODEL_CODE

INSTALL_SITE_ID

INSTALL_SITE_NAME

ASSET_CATEGORY

ASSET_ATTRIBUTE_CATEGORY

ASSET_ATTRIBUTE_CHAR1

ASSET_ATTRIBUTE_CHAR10

ASSET_ATTRIBUTE_CHAR11

ASSET_ATTRIBUTE_CHAR12

ASSET_ATTRIBUTE_CHAR13

ASSET_ATTRIBUTE_CHAR14

ASSET_ATTRIBUTE_CHAR15

ASSET_ATTRIBUTE_CHAR2

ASSET_ATTRIBUTE_CHAR3

ASSET_ATTRIBUTE_CHAR4

ASSET_ATTRIBUTE_CHAR5

ASSET_ATTRIBUTE_CHAR6

ASSET_ATTRIBUTE_CHAR7

ASSET_ATTRIBUTE_CHAR8

ASSET_ATTRIBUTE_CHAR9

ASSET_ATTRIBUTE_NUMBER1

ASSET_ATTRIBUTE_NUMBER2

ASSET_ATTRIBUTE_NUMBER3

ASSET_ATTRIBUTE_NUMBER4

ASSET_ATTRIBUTE_NUMBER5

ASSET_ATTRIBUTE_DATE1

ASSET_ATTRIBUTE_DATE2

ASSET_ATTRIBUTE_DATE3

ASSET_ATTRIBUTE_DATE4

ASSET_ATTRIBUTE_DATE5

PROP_NUM

PROP_DESC

PROP_CODE

PROP_HIER_CODE

PROP_TYPE

PROP_LOCATION_NAME

Query

SQL_Statement

SELECT

flala.lease_asset_id lease_asset_id,

flala.asset_number payment_asset_number,

flala.lease_detail_id asset_lease_detail_id,

flala.inventory_item_id inventory_item_id,

flala.item_category_code item_category_code,

flala.asset_model_code asset_model_code,

flala.install_site_id install_site_id,

hrl.location_name install_site_name,

(

SELECT

segment1

FROM

fa_categories_b facat,

egp_system_items_vl itm

WHERE

itm.inventory_item_id = flala.inventory_item_id

AND facat.category_id = itm.asset_category_id

) asset_category,

flala.attribute_category asset_attribute_category,

flala.attribute_char1 asset_attribute_char1,

flala.attribute_char10 asset_attribute_char10,

flala.attribute_char11 asset_attribute_char11,

flala.attribute_char12 asset_attribute_char12,

flala.attribute_char13 asset_attribute_char13,

flala.attribute_char14 asset_attribute_char14,

flala.attribute_char15 asset_attribute_char15,

flala.attribute_char2 asset_attribute_char2,

flala.attribute_char3 asset_attribute_char3,

flala.attribute_char4 asset_attribute_char4,

flala.attribute_char5 asset_attribute_char5,

flala.attribute_char6 asset_attribute_char6,

flala.attribute_char7 asset_attribute_char7,

flala.attribute_char8 asset_attribute_char8,

flala.attribute_char9 asset_attribute_char9,

flala.attribute_number1 asset_attribute_number1,

flala.attribute_number2 asset_attribute_number2,

flala.attribute_number3 asset_attribute_number3,

flala.attribute_number4 asset_attribute_number4,

flala.attribute_number5 asset_attribute_number5,

flala.attribute_date1 asset_attribute_date1,

flala.attribute_date2 asset_attribute_date2,

flala.attribute_date3 asset_attribute_date3,

flala.attribute_date4 asset_attribute_date4,

flala.attribute_date5 asset_attribute_date5,

p.property_number prop_num,

p.property_description prop_desc,

p.property_code prop_code,

p.hierarchical_property_code prop_hier_code,

p.property_type_code prop_type,

p.property_location_name prop_location_name

FROM

fla_lease_assets flala,

(SELECT

flapa.property_id,

flapa.property_number,

flapa.property_description,

flapa.property_code,

flapa.hierarchical_property_code,

flapta.property_type_code,

hrlp.location_name property_location_name

FROM

fla_properties_all flapa,

fla_property_types_all flapta,

hr_locations hrlp

WHERE

flapa.property_type_id = flapta.property_type_id

AND flapa.internal_location_id = hrlp.location_id(+)) p,

hr_locations hrl

WHERE

flala.install_site_id = hrl.location_id(+)

AND flala.property_id = p.property_id(+)