1. Tables and Views for Financials
  2. FLA_XLA_REV_EQP_PAYASSET_REF_V

FLA_XLA_REV_EQP_PAYASSET_REF_V

Details

  • Schema: FUSION

  • Object owner: FUN

  • Object type: VIEW

Columns

Name

PAY_LEASE_ASSET_ID

PAY_ASSET_NUMBER

PAY_ASSET_LEASE_DETAIL_ID

PAY_INVENTORY_ITEM_ID

PAY_ITEM_CATEGORY_CODE

PAY_ASSET_MODEL_CODE

PAY_ASSET_CATEGORY

PAY_ASSET_ATTRIBUTE_CATEGORY

PAY_ASSET_ATTRIBUTE_CHAR1

PAY_ASSET_ATTRIBUTE_CHAR10

PAY_ASSET_ATTRIBUTE_CHAR11

PAY_ASSET_ATTRIBUTE_CHAR12

PAY_ASSET_ATTRIBUTE_CHAR13

PAY_ASSET_ATTRIBUTE_CHAR14

PAY_ASSET_ATTRIBUTE_CHAR15

PAY_ASSET_ATTRIBUTE_CHAR2

PAY_ASSET_ATTRIBUTE_CHAR3

PAY_ASSET_ATTRIBUTE_CHAR4

PAY_ASSET_ATTRIBUTE_CHAR5

PAY_ASSET_ATTRIBUTE_CHAR6

PAY_ASSET_ATTRIBUTE_CHAR7

PAY_ASSET_ATTRIBUTE_CHAR8

PAY_ASSET_ATTRIBUTE_CHAR9

PAY_ASSET_ATTRIBUTE_NUMBER1

PAY_ASSET_ATTRIBUTE_NUMBER2

PAY_ASSET_ATTRIBUTE_NUMBER3

PAY_ASSET_ATTRIBUTE_NUMBER4

PAY_ASSET_ATTRIBUTE_NUMBER5

PAY_ASSET_ATTRIBUTE_DATE1

PAY_ASSET_ATTRIBUTE_DATE2

PAY_ASSET_ATTRIBUTE_DATE3

PAY_ASSET_ATTRIBUTE_DATE4

PAY_ASSET_ATTRIBUTE_DATE5

PAY_FINANCED_ITEM_TYPE_CODE

PAY_ASSET_TEMPLATE_NAME

Query

SQL_Statement

SELECT

flala.lease_asset_id pay_lease_asset_id,

flala.asset_number pay_asset_number,

flala.lease_detail_id pay_asset_lease_detail_id,

flala.inventory_item_id pay_inventory_item_id,

flala.item_category_code pay_item_category_code,

flala.asset_model_code pay_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

) pay_asset_category,

flala.attribute_category pay_asset_attribute_category,

flala.attribute_char1 pay_asset_attribute_char1,

flala.attribute_char10 pay_asset_attribute_char10,

flala.attribute_char11 pay_asset_attribute_char11,

flala.attribute_char12 pay_asset_attribute_char12,

flala.attribute_char13 pay_asset_attribute_char13,

flala.attribute_char14 pay_asset_attribute_char14,

flala.attribute_char15 pay_asset_attribute_char15,

flala.attribute_char2 pay_asset_attribute_char2,

flala.attribute_char3 pay_asset_attribute_char3,

flala.attribute_char4 pay_asset_attribute_char4,

flala.attribute_char5 pay_asset_attribute_char5,

flala.attribute_char6 pay_asset_attribute_char6,

flala.attribute_char7 pay_asset_attribute_char7,

flala.attribute_char8 pay_asset_attribute_char8,

flala.attribute_char9 pay_asset_attribute_char9,

flala.attribute_number1 pay_asset_attribute_number1,

flala.attribute_number2 pay_asset_attribute_number2,

flala.attribute_number3 pay_asset_attribute_number3,

flala.attribute_number4 pay_asset_attribute_number4,

flala.attribute_number5 pay_asset_attribute_number5,

flala.attribute_date1 pay_asset_attribute_date1,

flala.attribute_date2 pay_asset_attribute_date2,

flala.attribute_date3 pay_asset_attribute_date3,

flala.attribute_date4 pay_asset_attribute_date4,

flala.attribute_date5 pay_asset_attribute_date5,

flala.financed_item_type_code pay_financed_item_type_code,

flata.asset_template_name pay_asset_template_name

FROM

fla_lease_assets flala,

fla_asset_templates_all flata

WHERE flala.asset_template_id = flata.asset_template_id