1. Tables and Views for Financials
  2. FLA_XLA_REV_EQP_ASSET_REF_V

FLA_XLA_REV_EQP_ASSET_REF_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

LEASE_ASSET_ID

LEASE_ASSET_NUMBER

ASSET_LEASE_DETAIL_ID

INVENTORY_ITEM_ID

ITEM_CATEGORY_CODE

ASSET_MODEL_CODE

ASSET_CATEGORY

ASSET_PAYMENT_CATEGORY_CODE

ASSET_PAYMENT_NUMBER

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

FINANCED_ITEM_TYPE_CODE

ASSET_TEMPLATE_NAME

Query

SQL_Statement

SELECT

flala.lease_asset_id lease_asset_id,

flala.asset_number lease_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,

(

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,

'RENT' asset_payment_category_code,

'00000' asset_payment_number,

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,

flala.financed_item_type_code financed_item_type_code,

flata.asset_template_name asset_template_name

FROM

fla_lease_assets flala,

fla_asset_templates_all flata

WHERE flala.asset_template_id = flata.asset_template_id