FLA_AP_LEASE_EXTRACT_V

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

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_DATE1 ASSET_ATTRIBUTE_DATE2 ASSET_ATTRIBUTE_DATE3 ASSET_ATTRIBUTE_DATE4 ASSET_ATTRIBUTE_DATE5 ASSET_ATTRIBUTE_NUMBER1 ASSET_ATTRIBUTE_NUMBER2 ASSET_ATTRIBUTE_NUMBER3 ASSET_ATTRIBUTE_NUMBER4 ASSET_ATTRIBUTE_NUMBER5 ASSET_CATEGORY ASSET_NUMBER DETAILS_ATTRIBUTE_CATEGORY DETAILS_ATTRIBUTE_CHAR1 DETAILS_ATTRIBUTE_CHAR10 DETAILS_ATTRIBUTE_CHAR11 DETAILS_ATTRIBUTE_CHAR12 DETAILS_ATTRIBUTE_CHAR13 DETAILS_ATTRIBUTE_CHAR14 DETAILS_ATTRIBUTE_CHAR15 DETAILS_ATTRIBUTE_CHAR2 DETAILS_ATTRIBUTE_CHAR3 DETAILS_ATTRIBUTE_CHAR4 DETAILS_ATTRIBUTE_CHAR5 DETAILS_ATTRIBUTE_CHAR6 DETAILS_ATTRIBUTE_CHAR7 DETAILS_ATTRIBUTE_CHAR8 DETAILS_ATTRIBUTE_CHAR9 DETAILS_ATTRIBUTE_DATE1 DETAILS_ATTRIBUTE_DATE2 DETAILS_ATTRIBUTE_DATE3 DETAILS_ATTRIBUTE_DATE4 DETAILS_ATTRIBUTE_DATE5 DETAILS_ATTRIBUTE_NUMBER1 DETAILS_ATTRIBUTE_NUMBER2 DETAILS_ATTRIBUTE_NUMBER3 DETAILS_ATTRIBUTE_NUMBER4 DETAILS_ATTRIBUTE_NUMBER5 INSTALL_SITE_NAME ITEM_CATEGORY_CODE LEASE_ASSET_TYPE_CODE LEASE_CLASSIFICATION_CODE LEASE_NUMBER LIABILITY_FLAG OPTION_TYPE_CODE PAYMENT_ATTRIBUTE_CATEGORY PAYMENT_ATTRIBUTE_CHAR1 PAYMENT_ATTRIBUTE_CHAR10 PAYMENT_ATTRIBUTE_CHAR11 PAYMENT_ATTRIBUTE_CHAR12 PAYMENT_ATTRIBUTE_CHAR13 PAYMENT_ATTRIBUTE_CHAR14 PAYMENT_ATTRIBUTE_CHAR15 PAYMENT_ATTRIBUTE_CHAR2 PAYMENT_ATTRIBUTE_CHAR3 PAYMENT_ATTRIBUTE_CHAR4 PAYMENT_ATTRIBUTE_CHAR5 PAYMENT_ATTRIBUTE_CHAR6 PAYMENT_ATTRIBUTE_CHAR7 PAYMENT_ATTRIBUTE_CHAR8 PAYMENT_ATTRIBUTE_CHAR9 PAYMENT_ATTRIBUTE_DATE1 PAYMENT_ATTRIBUTE_DATE2 PAYMENT_ATTRIBUTE_DATE3 PAYMENT_ATTRIBUTE_DATE4 PAYMENT_ATTRIBUTE_DATE5 PAYMENT_ATTRIBUTE_NUMBER1 PAYMENT_ATTRIBUTE_NUMBER2 PAYMENT_ATTRIBUTE_NUMBER3 PAYMENT_ATTRIBUTE_NUMBER4 PAYMENT_ATTRIBUTE_NUMBER5 PAYMENT_PURPOSE_CODE PAYMENT_TYPE_CODE ROU_ASSET_FLAG SCHEDULE_TYPE_CODE TRANSACTION_TYPE_CODE LEASE_TYPE_CODE PARTY_NAME PROP_HIER_CODE PROP_CODE PROP_TYPE PROP_DESC PROP_NUM LEASE_ID LEASE_DETAIL_ID PAYMENT_NUMBER PAYMENT_ITEM_ID PROPERTY_ID PROPERTY_TYPE_ID INSTALL_SITE_ID PRODUCT_TABLE

Query

SQL_Statement

SELECT fas.attribute_category asset_attribute_category ,fas.attribute_char1 asset_attribute_char1 ,fas.attribute_char10 asset_attribute_char10 ,fas.attribute_char11 asset_attribute_char11 ,fas.attribute_char12 asset_attribute_char12 ,fas.attribute_char13 asset_attribute_char13 ,fas.attribute_char14 asset_attribute_char14 ,fas.attribute_char15 asset_attribute_char15 ,fas.attribute_char2 asset_attribute_char2 ,fas.attribute_char3 asset_attribute_char3 ,fas.attribute_char4 asset_attribute_char4 ,fas.attribute_char5 asset_attribute_char5 ,fas.attribute_char6 asset_attribute_char6 ,fas.attribute_char7 asset_attribute_char7 ,fas.attribute_char8 asset_attribute_char8 ,fas.attribute_char9 asset_attribute_char9 ,fas.attribute_date1 asset_attribute_date1 ,fas.attribute_date2 asset_attribute_date2 ,fas.attribute_date3 asset_attribute_date3 ,fas.attribute_date4 asset_attribute_date4 ,fas.attribute_date5 asset_attribute_date5 ,fas.attribute_number1 asset_attribute_number1 ,fas.attribute_number2 asset_attribute_number2 ,fas.attribute_number3 asset_attribute_number3 ,fas.attribute_number4 asset_attribute_number4 ,fas.attribute_number5 asset_attribute_number5 ,NULL asset_category ,fas.asset_number ,fld.attribute_category details_attribute_category ,fld.attribute_char1 details_attribute_char1 ,fld.attribute_char10 details_attribute_char10 ,fld.attribute_char11 details_attribute_char11 ,fld.attribute_char12 details_attribute_char12 ,fld.attribute_char13 details_attribute_char13 ,fld.attribute_char14 details_attribute_char14 ,fld.attribute_char15 details_attribute_char15 ,fld.attribute_char2 details_attribute_char2 ,fld.attribute_char3 details_attribute_char3 ,fld.attribute_char4 details_attribute_char4 ,fld.attribute_char5 details_attribute_char5 ,fld.attribute_char6 details_attribute_char6 ,fld.attribute_char7 details_attribute_char7 ,fld.attribute_char8 details_attribute_char8 ,fld.attribute_char9 details_attribute_char9 ,fld.attribute_date1 details_attribute_date1 ,fld.attribute_date2 details_attribute_date2 ,fld.attribute_date3 details_attribute_date3 ,fld.attribute_date4 details_attribute_date4 ,fld.attribute_date5 details_attribute_date5 ,fld.attribute_number1 details_attribute_number1 ,fld.attribute_number2 details_attribute_number2 ,fld.attribute_number3 details_attribute_number3 ,fld.attribute_number4 details_attribute_number4 ,fld.attribute_number5 details_attribute_number5 ,(select hrloc.internal_location_code from hr_locations hrloc where hrloc.location_id = fas.INSTALL_SITE_ID ) install_site_name ,fas.item_category_code item_category_code ,fl.lease_asset_type_code lease_asset_type_code ,fld.lease_classification_code lease_classification_code ,fl.lease_number lease_number ,fph.liability_flag liability_flag ,fph.option_type_code option_type_code ,fph.attribute_category payment_attribute_category ,fph.attribute_char1 payment_attribute_char1 ,fph.attribute_char10 payment_attribute_char10 ,fph.attribute_char11 payment_attribute_char11 ,fph.attribute_char12 payment_attribute_char12 ,fph.attribute_char13 payment_attribute_char13 ,fph.attribute_char14 payment_attribute_char14 ,fph.attribute_char15 payment_attribute_char15 ,fph.attribute_char2 payment_attribute_char2 ,fph.attribute_char3 payment_attribute_char3 ,fph.attribute_char4 payment_attribute_char4 ,fph.attribute_char5 payment_attribute_char5 ,fph.attribute_char6 payment_attribute_char6 ,fph.attribute_char7 payment_attribute_char7 ,fph.attribute_char8 payment_attribute_char8 ,fph.attribute_char9 payment_attribute_char9 ,fph.attribute_date1 payment_attribute_date1 ,fph.attribute_date2 payment_attribute_date2 ,fph.attribute_date3 payment_attribute_date3 ,fph.attribute_date4 payment_attribute_date4 ,fph.attribute_date5 payment_attribute_date5 ,fph.attribute_number1 payment_attribute_number1 ,fph.attribute_number2 payment_attribute_number2 ,fph.attribute_number3 payment_attribute_number3 ,fph.attribute_number4 payment_attribute_number4 ,fph.attribute_number5 payment_attribute_number5 ,fph.payment_purpose_code payment_purpose_code ,fph.payment_type_code payment_type_code ,fph.rou_asset_flag rou_asset_flag ,fph.schedule_type_code schedule_type_code ,fld.transaction_type_code transaction_type_code ,fl.lease_type_code lease_type_code ,(select PartyPEO.PARTY_NAME from POZ_SUPPLIERS SupplierPEO, HZ_PARTIES PartyPEO where SupplierPEO.PARTY_ID = PartyPEO.PARTY_ID and SupplierPEO.vendor_id = fl.vendor_id) party_name ,fpa.hierarchical_property_code prop_hier_code ,fpa.property_code prop_code , ( SELECT fpt.property_type_code FROM fla_property_types_all fpt WHERE fpt.property_type_id = fpa.property_type_id ) prop_type ,fpa.property_description prop_desc ,fpa.property_number prop_num ,fl.lease_id lease_id ,fld.lease_detail_id lease_detail_id ,fph.payment_number payment_number ,fpi.payment_item_id payment_item_id ,fpa.property_id property_id ,fpa.property_type_id property_type_id ,fas.install_site_id install_site_id , 'FLA_PAYMENT_ITEMS' product_table FROM fla_leases_all fl ,fla_lease_details fld ,fla_lease_assets fas ,fla_lease_payment_headers fph ,fla_payment_items fpi ,fla_properties_all fpa WHERE fl.lease_id = fld.lease_id AND fld.lease_id = fpi.lease_id AND fld.lease_detail_id = fpi.lease_detail_id AND fpi.payment_number = fph.payment_number AND fpi.lease_detail_id = fph.lease_detail_id AND fpi.lease_id = fph.lease_id AND fph.asset_number = fas.asset_number (+) AND fph.lease_id = fas.lease_id (+) AND fph.lease_detail_id = fas.lease_detail_id (+) AND fas.property_id = fpa.property_id (+)