CST_XLA_ASSETS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
CST_WORK_ORDER_ID ASSET_OPERATING_ORG_ID ASSET_MAINTENANCE_ORG_ID ASSET_ID ASSET_NUMBER ASSET_TAG ASSET_ITEM_NUMBER ASSET_ITEM_CLASS_ID ASSET_LOT_NUMBER ASSET_SERIAL_NUMBER ASSET_LOCATION_TYPE ASSET_WORK_CENTER_ID ASSET_WORK_AREA_ID ASSET_CUSTOMER_ID ASSET_LOCATION_ORG_ID ASSET_ATTRIBUTE_CATEGORY ASSET_ATTRIBUTE_CHAR1 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_CHAR10 ASSET_ATTRIBUTE_CHAR11 ASSET_ATTRIBUTE_CHAR12 ASSET_ATTRIBUTE_CHAR13 ASSET_ATTRIBUTE_CHAR14 ASSET_ATTRIBUTE_CHAR15 ASSET_ATTRIBUTE_CHAR16 ASSET_ATTRIBUTE_CHAR17 ASSET_ATTRIBUTE_CHAR18 ASSET_ATTRIBUTE_CHAR19 ASSET_ATTRIBUTE_CHAR20 ASSET_ATTRIBUTE_CHAR21 ASSET_ATTRIBUTE_CHAR22 ASSET_ATTRIBUTE_CHAR23 ASSET_ATTRIBUTE_CHAR24 ASSET_ATTRIBUTE_CHAR25 ASSET_ATTRIBUTE_CHAR26 ASSET_ATTRIBUTE_CHAR27 ASSET_ATTRIBUTE_CHAR28 ASSET_ATTRIBUTE_CHAR29 ASSET_ATTRIBUTE_CHAR30 ASSET_ATTRIBUTE_NUMBER1 ASSET_ATTRIBUTE_NUMBER2 ASSET_ATTRIBUTE_NUMBER3 ASSET_ATTRIBUTE_NUMBER4 ASSET_ATTRIBUTE_NUMBER5 ASSET_ATTRIBUTE_NUMBER6 ASSET_ATTRIBUTE_NUMBER7 ASSET_ATTRIBUTE_NUMBER8 ASSET_ATTRIBUTE_NUMBER9 ASSET_ATTRIBUTE_NUMBER10 ASSET_ATTRIBUTE_DATE1 ASSET_ATTRIBUTE_DATE2 ASSET_ATTRIBUTE_DATE3 ASSET_ATTRIBUTE_DATE4 ASSET_ATTRIBUTE_DATE5 ASSET_ATTRIBUTE_TIMESTAMP1 ASSET_ATTRIBUTE_TIMESTAMP2 ASSET_ATTRIBUTE_TIMESTAMP3 ASSET_ATTRIBUTE_TIMESTAMP4 ASSET_ATTRIBUTE_TIMESTAMP5

Name

CST_WORK_ORDER_ID

ASSET_OPERATING_ORG_ID

ASSET_MAINTENANCE_ORG_ID

ASSET_ID

ASSET_NUMBER

ASSET_TAG

ASSET_ITEM_NUMBER

ASSET_ITEM_CLASS_ID

ASSET_LOT_NUMBER

ASSET_SERIAL_NUMBER

ASSET_LOCATION_TYPE

ASSET_WORK_CENTER_ID

ASSET_WORK_AREA_ID

ASSET_CUSTOMER_ID

ASSET_LOCATION_ORG_ID

ASSET_ATTRIBUTE_CATEGORY

ASSET_ATTRIBUTE_CHAR1

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_CHAR10

ASSET_ATTRIBUTE_CHAR11

ASSET_ATTRIBUTE_CHAR12

ASSET_ATTRIBUTE_CHAR13

ASSET_ATTRIBUTE_CHAR14

ASSET_ATTRIBUTE_CHAR15

ASSET_ATTRIBUTE_CHAR16

ASSET_ATTRIBUTE_CHAR17

ASSET_ATTRIBUTE_CHAR18

ASSET_ATTRIBUTE_CHAR19

ASSET_ATTRIBUTE_CHAR20

ASSET_ATTRIBUTE_CHAR21

ASSET_ATTRIBUTE_CHAR22

ASSET_ATTRIBUTE_CHAR23

ASSET_ATTRIBUTE_CHAR24

ASSET_ATTRIBUTE_CHAR25

ASSET_ATTRIBUTE_CHAR26

ASSET_ATTRIBUTE_CHAR27

ASSET_ATTRIBUTE_CHAR28

ASSET_ATTRIBUTE_CHAR29

ASSET_ATTRIBUTE_CHAR30

ASSET_ATTRIBUTE_NUMBER1

ASSET_ATTRIBUTE_NUMBER2

ASSET_ATTRIBUTE_NUMBER3

ASSET_ATTRIBUTE_NUMBER4

ASSET_ATTRIBUTE_NUMBER5

ASSET_ATTRIBUTE_NUMBER6

ASSET_ATTRIBUTE_NUMBER7

ASSET_ATTRIBUTE_NUMBER8

ASSET_ATTRIBUTE_NUMBER9

ASSET_ATTRIBUTE_NUMBER10

ASSET_ATTRIBUTE_DATE1

ASSET_ATTRIBUTE_DATE2

ASSET_ATTRIBUTE_DATE3

ASSET_ATTRIBUTE_DATE4

ASSET_ATTRIBUTE_DATE5

ASSET_ATTRIBUTE_TIMESTAMP1

ASSET_ATTRIBUTE_TIMESTAMP2

ASSET_ATTRIBUTE_TIMESTAMP3

ASSET_ATTRIBUTE_TIMESTAMP4

ASSET_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement
SELECT cwo.cst_work_order_id cst_work_order_id, ca.item_organization_id asset_operating_org_id, cwo.inventory_organization_id asset_maintenance_org_id, ca.asset_id asset_id, ca.asset_number asset_number, ca.asset_tag asset_tag, esi.item_number asset_item_number, esi.item_catalog_group_id asset_item_class_id, ca.lot_number asset_lot_number, ca.serial_number asset_serial_number, ca.current_location_context asset_location_type, ca.work_center_id asset_work_center_id, wwc.work_area_id asset_work_area_id, ca.customer_id asset_customer_id, ca.location_organization_id asset_location_org_id, ca.attribute_category asset_attribute_category, ca.attribute_char1 asset_attribute_char1, ca.attribute_char2 asset_attribute_char2, ca.attribute_char3 asset_attribute_char3, ca.attribute_char4 asset_attribute_char4, ca.attribute_char5 asset_attribute_char5, ca.attribute_char6 asset_attribute_char6, ca.attribute_char7 asset_attribute_char7, ca.attribute_char8 asset_attribute_char8, ca.attribute_char9 asset_attribute_char9, ca.attribute_char10 asset_attribute_char10, ca.attribute_char11 asset_attribute_char11, ca.attribute_char12 asset_attribute_char12, ca.attribute_char13 asset_attribute_char13, ca.attribute_char14 asset_attribute_char14, ca.attribute_char15 asset_attribute_char15, ca.attribute_char16 asset_attribute_char16, ca.attribute_char17 asset_attribute_char17, ca.attribute_char18 asset_attribute_char18, ca.attribute_char19 asset_attribute_char19, ca.attribute_char20 asset_attribute_char20, ca.attribute_char21 asset_attribute_char21, ca.attribute_char22 asset_attribute_char22, ca.attribute_char23 asset_attribute_char23, ca.attribute_char24 asset_attribute_char24, ca.attribute_char25 asset_attribute_char25, ca.attribute_char26 asset_attribute_char26, ca.attribute_char27 asset_attribute_char27, ca.attribute_char28 asset_attribute_char28, ca.attribute_char29 asset_attribute_char29, ca.attribute_char30 asset_attribute_char30, ca.attribute_number1 asset_attribute_number1, ca.attribute_number2 asset_attribute_number2, ca.attribute_number3 asset_attribute_number3, ca.attribute_number4 asset_attribute_number4, ca.attribute_number5 asset_attribute_number5, ca.attribute_number6 asset_attribute_number6, ca.attribute_number7 asset_attribute_number7, ca.attribute_number8 asset_attribute_number8, ca.attribute_number9 asset_attribute_number9, ca.attribute_number10 asset_attribute_number10, ca.attribute_date1 asset_attribute_date1, ca.attribute_date2 asset_attribute_date2, ca.attribute_date3 asset_attribute_date3, ca.attribute_date4 asset_attribute_date4, ca.attribute_date5 asset_attribute_date5, ca.attribute_timestamp1 asset_attribute_timestamp1, ca.attribute_timestamp2 asset_attribute_timestamp2, ca.attribute_timestamp3 asset_attribute_timestamp3, ca.attribute_timestamp4 asset_attribute_timestamp4, ca.attribute_timestamp5 asset_attribute_timestamp5 FROM cst_work_orders cwo, wis_work_methods_b wwm, wie_wo_assets wwa, cse_assets_vl ca, wis_work_centers_vl wwc, egp_system_items_bv esi, wie_wo_operations_v wwoo WHERE cwo.external_system_reference = 'FUSION' AND cwo.external_system_ref_id = wwa.work_order_id AND wwm.work_method_id = cwo.work_method_id AND wwm.work_method_code = 'MAINTENANCE' AND wwa.asset_id = ca.asset_id AND wwc.work_center_id (+) = ca.work_center_id AND esi.inventory_item_id = ca.item_id AND esi.organization_id = ca.item_organization_id AND wwoo.wo_operation_id (+) = ca.work_order_operation_id

SQL_Statement

SELECT

cwo.cst_work_order_id cst_work_order_id,

ca.item_organization_id asset_operating_org_id,

cwo.inventory_organization_id asset_maintenance_org_id,

ca.asset_id asset_id,

ca.asset_number asset_number,

ca.asset_tag asset_tag,

esi.item_number asset_item_number,

esi.item_catalog_group_id asset_item_class_id,

ca.lot_number asset_lot_number,

ca.serial_number asset_serial_number,

ca.current_location_context asset_location_type,

ca.work_center_id asset_work_center_id,

wwc.work_area_id asset_work_area_id,

ca.customer_id asset_customer_id,

ca.location_organization_id asset_location_org_id,

ca.attribute_category asset_attribute_category,

ca.attribute_char1 asset_attribute_char1,

ca.attribute_char2 asset_attribute_char2,

ca.attribute_char3 asset_attribute_char3,

ca.attribute_char4 asset_attribute_char4,

ca.attribute_char5 asset_attribute_char5,

ca.attribute_char6 asset_attribute_char6,

ca.attribute_char7 asset_attribute_char7,

ca.attribute_char8 asset_attribute_char8,

ca.attribute_char9 asset_attribute_char9,

ca.attribute_char10 asset_attribute_char10,

ca.attribute_char11 asset_attribute_char11,

ca.attribute_char12 asset_attribute_char12,

ca.attribute_char13 asset_attribute_char13,

ca.attribute_char14 asset_attribute_char14,

ca.attribute_char15 asset_attribute_char15,

ca.attribute_char16 asset_attribute_char16,

ca.attribute_char17 asset_attribute_char17,

ca.attribute_char18 asset_attribute_char18,

ca.attribute_char19 asset_attribute_char19,

ca.attribute_char20 asset_attribute_char20,

ca.attribute_char21 asset_attribute_char21,

ca.attribute_char22 asset_attribute_char22,

ca.attribute_char23 asset_attribute_char23,

ca.attribute_char24 asset_attribute_char24,

ca.attribute_char25 asset_attribute_char25,

ca.attribute_char26 asset_attribute_char26,

ca.attribute_char27 asset_attribute_char27,

ca.attribute_char28 asset_attribute_char28,

ca.attribute_char29 asset_attribute_char29,

ca.attribute_char30 asset_attribute_char30,

ca.attribute_number1 asset_attribute_number1,

ca.attribute_number2 asset_attribute_number2,

ca.attribute_number3 asset_attribute_number3,

ca.attribute_number4 asset_attribute_number4,

ca.attribute_number5 asset_attribute_number5,

ca.attribute_number6 asset_attribute_number6,

ca.attribute_number7 asset_attribute_number7,

ca.attribute_number8 asset_attribute_number8,

ca.attribute_number9 asset_attribute_number9,

ca.attribute_number10 asset_attribute_number10,

ca.attribute_date1 asset_attribute_date1,

ca.attribute_date2 asset_attribute_date2,

ca.attribute_date3 asset_attribute_date3,

ca.attribute_date4 asset_attribute_date4,

ca.attribute_date5 asset_attribute_date5,

ca.attribute_timestamp1 asset_attribute_timestamp1,

ca.attribute_timestamp2 asset_attribute_timestamp2,

ca.attribute_timestamp3 asset_attribute_timestamp3,

ca.attribute_timestamp4 asset_attribute_timestamp4,

ca.attribute_timestamp5 asset_attribute_timestamp5

FROM

cst_work_orders cwo,

wis_work_methods_b wwm,

wie_wo_assets wwa,

cse_assets_vl ca,

wis_work_centers_vl wwc,

egp_system_items_bv esi,

wie_wo_operations_v wwoo

WHERE

cwo.external_system_reference = 'FUSION'

AND cwo.external_system_ref_id = wwa.work_order_id

AND wwm.work_method_id = cwo.work_method_id

AND wwm.work_method_code = 'MAINTENANCE'

AND wwa.asset_id = ca.asset_id

AND wwc.work_center_id (+) = ca.work_center_id

AND esi.inventory_item_id = ca.item_id

AND esi.organization_id = ca.item_organization_id

AND wwoo.wo_operation_id (+) = ca.work_order_operation_id