CSE_ASSETS_VL

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name

ASSET_ID OBJECT_VERSION_NUMBER ASSET_NUMBER DESCRIPTION ASSET_TAG ASSET_TRACKING_CODE GENEALOGY_ENABLED_FLAG DESCRIPTION_ASSET_FLAG ITEM_ID ITEM_ORGANIZATION_ID ITEM_REVISION SERIAL_NUMBER LOT_NUMBER GEN_OBJECT_ID QUANTITY UOM_CODE SECONDARY_QUANTITY SECONDARY_UOM_CODE ACTIVE_END_DATE STATUS_CODE COMPETITOR_ASSET_FLAG NEW_WO_ALLOWED_FLAG IOT_ENABLED_FLAG CURRENT_LOCATION_CONTEXT CURRENT_LOCATION_ID LOCATION_ORGANIZATION_ID SUBINVENTORY_CODE INVENTORY_LOCATOR_ID WORK_ORDER_ID WORK_ORDER_OPERATION_ID WORK_CENTER_ID PROJECT_ID TASK_ID EXTERNAL_LOCATION PARTIALLY_FINISHED_FLAG UNASSIGNED_FLAG INSTALLED_LOCATION_CONTEXT INSTALLED_LOCATION_ID SHIPMENT_DATE INSTALLED_DATE IN_SERVICE_DATE PURCHASE_DATE ORIGINATION_DATE REGISTERED_FLAG REGISTRATION_DATE CUSTOMER_ASSET_START_DATE CUSTOMER_ASSET_END_DATE SOLD_BY_BUSINESS_UNIT_ID SALES_ORDER_SOURCE_SYSTEM_TYPE SALES_ORDER_SOURCE_SYSTEM SALES_ORDER_NUMBER SALES_ORDER_ID SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_ID CUSTOMER_ID CUSTOMER_PARTY_TYPE CUSTOMER_SITE_PARTY_ID CUSTOMER_SITE_ID CUSTOMER_BILLING_PARTY_ID CUSTOMER_BILLING_PARTY_SITE_ID CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_SITE_ID CUSTOMER_ACCOUNT_SITE_USE_ID CONTACT_ID SUPPLIER_ID SUPPLIER_SITE_ID COUNTRY_OF_ORIGIN_CODE DFLT_WO_TYPE DFLT_WO_SUB_TYPE MAINTAINABLE_FLAG OWNED_BY USED_BY PARENT_ORDER_LINE_NUMBER PARENT_ORDER_LINE_ID FULFILL_LINE_ID PARENT_FULFILL_LINE_ID LOGICAL_FLAG SHIPMENT_ID SHIPMENT_NUMBER SPLIT_FROM_ASSET_ID BOM_EXPLOSION_FLAG COMPONENT_SEQUENCE_ID QUANTITY_PER_ASSEMBLY EXTERNAL_SYSTEM_PACKING_UNIT RETURN_ORDER_ID RETURN_ORDER_LINE_ID RETURN_ORDER_FULFILL_LINE_ID CONFIG_HEADER_ID CONFIG_REVISION_NUMBER CRITICALITY_CODE ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB005 CURRENCY_CODE CORP_CURRENCY_CODE CURCY_CONV_RATE_TYPE VLD_ORGANIZATION_ID PARENT_ASSET_ID ROOT_ASSET_ID LOGICAL_ROOT_ASSET_ID

Query

SQL_Statement

SELECT CAB.ASSET_ID ASSET_ID, CAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CAB.ASSET_NUMBER ASSET_NUMBER, CAT.DESCRIPTION DESCRIPTION, CAB.ASSET_TAG ASSET_TAG, CAB.ASSET_TRACKING_CODE ASSET_TRACKING_CODE, CAB.GENEALOGY_ENABLED_FLAG GENEALOGY_ENABLED_FLAG, NVL(CAB.DESCRIPTION_ASSET_FLAG, 'N') DESCRIPTION_ASSET_FLAG, CAB.ITEM_ID ITEM_ID, CAB.ITEM_ORGANIZATION_ID ITEM_ORGANIZATION_ID, CAB.ITEM_REVISION ITEM_REVISION, CAB.SERIAL_NUMBER SERIAL_NUMBER, CAB.LOT_NUMBER LOT_NUMBER, CAB.GEN_OBJECT_ID GEN_OBJECT_ID, CAB.QUANTITY QUANTITY, CAB.UOM_CODE UOM_CODE, CAB.SECONDARY_QUANTITY SECONDARY_QUANTITY, CAB.SECONDARY_UOM_CODE SECONDARY_UOM_CODE, CAB.ACTIVE_END_DATE ACTIVE_END_DATE, CAB.STATUS_CODE STATUS_CODE, NVL(CAB.COMPETITOR_ASSET_FLAG, 'N') COMPETITOR_ASSET_FLAG, CAB.NEW_WO_ALLOWED_FLAG NEW_WO_ALLOWED_FLAG, CAB.IOT_ENABLED_FLAG IOT_ENABLED_FLAG, CAB.CURRENT_LOCATION_CONTEXT CURRENT_LOCATION_CONTEXT, CAB.CURRENT_LOCATION_ID CURRENT_LOCATION_ID, CAB.LOCATION_ORGANIZATION_ID LOCATION_ORGANIZATION_ID, CAB.SUBINVENTORY_CODE SUBINVENTORY_CODE, CAB.INVENTORY_LOCATOR_ID INVENTORY_LOCATOR_ID, CAB.WORK_ORDER_ID WORK_ORDER_ID, CAB.WORK_ORDER_OPERATION_ID WORK_ORDER_OPERATION_ID, CAB.WORK_CENTER_ID WORK_CENTER_ID, CAB.PROJECT_ID PROJECT_ID, CAB.TASK_ID TASK_ID, CAB.EXTERNAL_LOCATION EXTERNAL_LOCATION, CAB.PARTIALLY_FINISHED_FLAG PARTIALLY_FINISHED_FLAG, CAB.UNASSIGNED_FLAG UNASSIGNED_FLAG, CAB.INSTALLED_LOCATION_CONTEXT INSTALLED_LOCATION_CONTEXT, CAB.INSTALLED_LOCATION_ID INSTALLED_LOCATION_ID, CAB.SHIPMENT_DATE SHIPMENT_DATE, CAB.INSTALLED_DATE INSTALLED_DATE, CAB.IN_SERVICE_DATE IN_SERVICE_DATE, CAB.PURCHASE_DATE PURCHASE_DATE, CAB.ORIGINATION_DATE ORIGINATION_DATE, CAB.REGISTERED_FLAG REGISTERED_FLAG, CAB.REGISTRATION_DATE REGISTRATION_DATE, CAB.CUSTOMER_ASSET_START_DATE CUSTOMER_ASSET_START_DATE, CAB.CUSTOMER_ASSET_END_DATE CUSTOMER_ASSET_END_DATE, CAB.SOLD_BY_BUSINESS_UNIT_ID SOLD_BY_BUSINESS_UNIT_ID, CAB.SALES_ORDER_SOURCE_SYSTEM_TYPE SALES_ORDER_SOURCE_SYSTEM_TYPE, CAB.SALES_ORDER_SOURCE_SYSTEM SALES_ORDER_SOURCE_SYSTEM, CAB.SALES_ORDER_NUMBER SALES_ORDER_NUMBER, CAB.SALES_ORDER_ID SALES_ORDER_ID, CAB.SALES_ORDER_LINE_NUMBER SALES_ORDER_LINE_NUMBER, CAB.SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID, CAB.CUSTOMER_ID CUSTOMER_ID, CAB.CUSTOMER_PARTY_TYPE CUSTOMER_PARTY_TYPE, CAB.CUSTOMER_SITE_PARTY_ID CUSTOMER_SITE_PARTY_ID, CAB.CUSTOMER_SITE_ID CUSTOMER_SITE_ID, CAB.CUSTOMER_BILLING_PARTY_ID CUSTOMER_BILLING_PARTY_ID, CAB.CUSTOMER_BILLING_PARTY_SITE_ID CUSTOMER_BILLING_PARTY_SITE_ID, CAB.CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_ID, CAB.CUSTOMER_ACCOUNT_SITE_ID CUSTOMER_ACCOUNT_SITE_ID, CAB.CUSTOMER_ACCOUNT_SITE_USE_ID CUSTOMER_ACCOUNT_SITE_USE_ID, CAB.CONTACT_ID CONTACT_ID, CAB.SUPPLIER_ID SUPPLIER_ID, CAB.SUPPLIER_SITE_ID SUPPLIER_SITE_ID, CAB.COUNTRY_OF_ORIGIN_CODE COUNTRY_OF_ORIGIN_CODE, CAB.DFLT_WO_TYPE DFLT_WO_TYPE, CAB.DFLT_WO_SUB_TYPE DFLT_WO_SUB_TYPE, CAB.MAINTAINABLE_FLAG MAINTAINABLE_FLAG, CAB.OWNED_BY OWNED_BY, CAB.USED_BY USED_BY, CAB.PARENT_ORDER_LINE_NUMBER PARENT_ORDER_LINE_NUMBER, CAB.PARENT_ORDER_LINE_ID PARENT_ORDER_LINE_ID, CAB.FULFILL_LINE_ID FULFILL_LINE_ID, CAB.PARENT_FULFILL_LINE_ID PARENT_FULFILL_LINE_ID, CAB.LOGICAL_FLAG LOGICAL_FLAG, CAB.SHIPMENT_ID SHIPMENT_ID, CAB.SHIPMENT_NUMBER SHIPMENT_NUMBER, CAB.SPLIT_FROM_ASSET_ID SPLIT_FROM_ASSET_ID, CAB.BOM_EXPLOSION_FLAG BOM_EXPLOSION_FLAG, CAB.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, CAB.QUANTITY_PER_ASSEMBLY QUANTITY_PER_ASSEMBLY, CAB.EXTERNAL_SYSTEM_PACKING_UNIT EXTERNAL_SYSTEM_PACKING_UNIT, CAB.RETURN_ORDER_ID RETURN_ORDER_ID, CAB.RETURN_ORDER_LINE_ID RETURN_ORDER_LINE_ID, CAB.RETURN_ORDER_FULFILL_LINE_ID RETURN_ORDER_FULFILL_LINE_ID, CAB.CONFIG_HEADER_ID CONFIG_HEADER_ID, CAB.CONFIG_REVISION_NUMBER CONFIG_REVISION_NUMBER, CAB.CRITICALITY_CODE CRITICALITY_CODE, CAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, CAB.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, CAB.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, CAB.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, CAB.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, CAB.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, CAB.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, CAB.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, CAB.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, CAB.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, CAB.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, CAB.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, CAB.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, CAB.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, CAB.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, CAB.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, CAB.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, CAB.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, CAB.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, CAB.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, CAB.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, CAB.ATTRIBUTE_CHAR21 ATTRIBUTE_CHAR21, CAB.ATTRIBUTE_CHAR22 ATTRIBUTE_CHAR22, CAB.ATTRIBUTE_CHAR23 ATTRIBUTE_CHAR23, CAB.ATTRIBUTE_CHAR24 ATTRIBUTE_CHAR24, CAB.ATTRIBUTE_CHAR25 ATTRIBUTE_CHAR25, CAB.ATTRIBUTE_CHAR26 ATTRIBUTE_CHAR26, CAB.ATTRIBUTE_CHAR27 ATTRIBUTE_CHAR27, CAB.ATTRIBUTE_CHAR28 ATTRIBUTE_CHAR28, CAB.ATTRIBUTE_CHAR29 ATTRIBUTE_CHAR29, CAB.ATTRIBUTE_CHAR30 ATTRIBUTE_CHAR30, CAB.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, CAB.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, CAB.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, CAB.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, CAB.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, CAB.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, CAB.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, CAB.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, CAB.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, CAB.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, CAB.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, CAB.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, CAB.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, CAB.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, CAB.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, CAB.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, CAB.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, CAB.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, CAB.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, CAB.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, CAB.CREATED_BY CREATED_BY, CAB.CREATION_DATE CREATION_DATE, CAB.LAST_UPDATED_BY LAST_UPDATED_BY, CAB.LAST_UPDATE_DATE LAST_UPDATE_DATE, CAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CAB.REQUEST_ID REQUEST_ID, CAB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, CAB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, CAB.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, CAB.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, CAB.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, CAB.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, CAB.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, CAB.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, CAB.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, CAB.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, CAB.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, CAB.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, CAB.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, CAB.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, CAB.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, CAB.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, CAB.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, CAB.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, CAB.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, CAB.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, CAB.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, CAB.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, CAB.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, CAB.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, CAB.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, CAB.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, CAB.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, CAB.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, CAB.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, CAB.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, CAB.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, CAB.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, CAB.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, CAB.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, CAB.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, CAB.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, CAB.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, CAB.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, CAB.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, CAB.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, CAB.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, CAB.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, CAB.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, CAB.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, CAB.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, CAB.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, CAB.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, CAB.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, CAB.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, CAB.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, CAB.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, CAB.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, CAB.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, CAB.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, CAB.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, CAB.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, CAB.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, CAB.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, CAB.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, CAB.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, CAB.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, CAB.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, CAB.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, CAB.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, CAB.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, CAB.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, CAB.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, CAB.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, CAB.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, CAB.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, CAB.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, CAB.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, CAB.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, CAB.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, CAB.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, CAB.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, CAB.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, CAB.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, CAB.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, CAB.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, CAB.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, CAB.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, CAB.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, CAB.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, CAB.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, CAB.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, CAB.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, CAB.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, CAB.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, CAB.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, CAB.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, CAB.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, CAB.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, CAB.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, CAB.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, CAB.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, CAB.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, CAB.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, CAB.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, CAB.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, CAB.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, CAB.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, CAB.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, CAB.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, CAB.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, CAB.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, CAB.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, CAB.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, CAB.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, CAB.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, CAB.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, CAB.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, CAB.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, CAB.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, CAB.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, CAB.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, CAB.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, CAB.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, CAB.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, CAB.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, CAB.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, CAB.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, CAB.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, CAB.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, CAB.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, CAB.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, CAB.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, CAB.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, CAB.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, CAB.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, CAB.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, CAB.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, CAB.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, CAB.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, CAB.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, CAB.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, CAB.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, CAB.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, CAB.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, CAB.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, CAB.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, CAB.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, CAB.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, CAB.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, CAB.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, CAB.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, CAB.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, CAB.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, CAB.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, CAB.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, CAB.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, CAB.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, CAB.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, CAB.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, CAB.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, CAB.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, CAB.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, CAB.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, CAB.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, CAB.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, CAB.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, CAB.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, CAB.EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB001, CAB.EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB002, CAB.EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB003, CAB.EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB004, CAB.EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB005, CAB.CURRENCY_CODE CURRENCY_CODE, CAB.CORP_CURRENCY_CODE CORP_CURRENCY_CODE, CAB.CURCY_CONV_RATE_TYPE CURCY_CONV_RATE_TYPE, CAB.VLD_ORGANIZATION_ID VLD_ORGANIZATION_ID, CAB.PARENT_ASSET_ID PARENT_ASSET_ID, CAB.ROOT_ASSET_ID ROOT_ASSET_ID, CAB.LOGICAL_ROOT_ASSET_ID LOGICAL_ROOT_ASSET_ID FROM CSE_ASSETS_B CAB, CSE_ASSETS_TL CAT WHERE CAT.ASSET_ID = CAB.ASSET_ID AND CAT.LANGUAGE = USERENV('LANG')