WIE_WO_TIA_VALUES

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
WORK_ORDER_ID ORGANIZATION_ID TIA_REF_LINE_ID TIA_REF_ENTITY INVENTORY_ITEM_ID ITEM_NUMBER ITEM_UOM_CODE BOM_ITEM_TYPE ATTRIBUTE_ID ATTRIBUTE_NAME ATTRIBUTE_DISPLAY_NAME ATTRIBUTE_DESCRIPTION ATTRIBUTE_DATA_TYPE ATTRIBUTE_UOM_CODE ATTRIBUTE_UNIT_OF_MEASURE NUMBER_ATTRIBUTE_VALUE CHARACTER_ATTRIBUTE_VALUE DATE_ATTRIBUTE_VALUE TIMESTAMP_ATTRIBUTE_VALUE

Name

WORK_ORDER_ID

ORGANIZATION_ID

TIA_REF_LINE_ID

TIA_REF_ENTITY

INVENTORY_ITEM_ID

ITEM_NUMBER

ITEM_UOM_CODE

BOM_ITEM_TYPE

ATTRIBUTE_ID

ATTRIBUTE_NAME

ATTRIBUTE_DISPLAY_NAME

ATTRIBUTE_DESCRIPTION

ATTRIBUTE_DATA_TYPE

ATTRIBUTE_UOM_CODE

ATTRIBUTE_UNIT_OF_MEASURE

NUMBER_ATTRIBUTE_VALUE

CHARACTER_ATTRIBUTE_VALUE

DATE_ATTRIBUTE_VALUE

TIMESTAMP_ATTRIBUTE_VALUE

Query

SQL_Statement
SELECT wo.work_order_id WORK_ORDER_ID, wo.organization_id ORGANIZATION_ID, cml.line_id TIA_REF_LINE_ID, 'CTO_MATCH_LINES' TIA_REF_ENTITY, cml.inventory_item_id INVENTORY_ITEM_ID, esi.item_number ITEM_NUMBER, cml.unit_uom ITEM_UOM_CODE, esi.bom_item_type BOM_ITEM_TYPE, eta.trans_attr_id ATTRIBUTE_ID, ctia.attribute_name ATTRIBUTE_NAME, eta.display_name ATTRIBUTE_DISPLAY_NAME, eta.description ATTRIBUTE_DESCRIPTION, eta.data_type_code ATTRIBUTE_DATA_TYPE, eta.uom_code ATTRIBUTE_UOM_CODE, uom.unit_of_measure ATTRIBUTE_UNIT_OF_MEASURE, ctia.number_attribute_value NUMBER_ATTRIBUTE_VALUE, ctia.character_attribute_value CHARACTER_ATTRIBUTE_VALUE, ctia.date_attribute_value DATE_ATTRIBUTE_VALUE, ctia.timestamp_attribute_value TIMESTAMP_ATTRIBUTE_VALUE FROM wie_work_orders_b wo, cto_match_headers cmh, cto_match_lines cml, cto_tia_v ctia, egp_system_items_vl esi, egp_trans_attrs_vl eta, inv_units_of_measure_vl uom WHERE wo.inventory_item_id = cmh.config_item_id AND wo.work_definition_id is not null AND cml.header_id = cmh.header_id AND ctia.line_id = cml.line_id AND esi.inventory_item_id = cml.inventory_item_id AND esi.organization_id = wo.organization_id AND eta.internal_name = ctia.attribute_name AND uom.uom_code(+) = eta.uom_code

SQL_Statement

SELECT

wo.work_order_id WORK_ORDER_ID,

wo.organization_id ORGANIZATION_ID,

cml.line_id TIA_REF_LINE_ID,

'CTO_MATCH_LINES' TIA_REF_ENTITY,

cml.inventory_item_id INVENTORY_ITEM_ID,

esi.item_number ITEM_NUMBER,

cml.unit_uom ITEM_UOM_CODE,

esi.bom_item_type BOM_ITEM_TYPE,

eta.trans_attr_id ATTRIBUTE_ID,

ctia.attribute_name ATTRIBUTE_NAME,

eta.display_name ATTRIBUTE_DISPLAY_NAME,

eta.description ATTRIBUTE_DESCRIPTION,

eta.data_type_code ATTRIBUTE_DATA_TYPE,

eta.uom_code ATTRIBUTE_UOM_CODE,

uom.unit_of_measure ATTRIBUTE_UNIT_OF_MEASURE,

ctia.number_attribute_value NUMBER_ATTRIBUTE_VALUE,

ctia.character_attribute_value CHARACTER_ATTRIBUTE_VALUE,

ctia.date_attribute_value DATE_ATTRIBUTE_VALUE,

ctia.timestamp_attribute_value TIMESTAMP_ATTRIBUTE_VALUE

FROM

wie_work_orders_b wo,

cto_match_headers cmh,

cto_match_lines cml,

cto_tia_v ctia,

egp_system_items_vl esi,

egp_trans_attrs_vl eta,

inv_units_of_measure_vl uom

WHERE wo.inventory_item_id = cmh.config_item_id

AND wo.work_definition_id is not null

AND cml.header_id = cmh.header_id

AND ctia.line_id = cml.line_id

AND esi.inventory_item_id = cml.inventory_item_id

AND esi.organization_id = wo.organization_id

AND eta.internal_name = ctia.attribute_name

AND uom.uom_code(+) = eta.uom_code