1. Tables and Views for SCM
  2. CSE_GENEALOGY_OBJ_REF_DTLS_V

CSE_GENEALOGY_OBJ_REF_DTLS_V

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: VIEW

Columns

Name

TRACKED_OBJECT_REF_ID

TRACKED_OBJECT_CODE

DATA_SOURCE_TYPE

DATA_SOURCE

PK_ATTRIBUTE1

PK_VALUE1

UK_ATTRIBUTE1

UK_VALUE1

PK_ATTRIBUTE2

PK_VALUE2

UK_ATTRIBUTE2

UK_VALUE2

PK_ATTRIBUTE3

PK_VALUE3

UK_ATTRIBUTE3

UK_VALUE3

PK_ATTRIBUTE4

PK_VALUE4

UK_ATTRIBUTE4

UK_VALUE4

SRC_TRANSACTION_DATE

TRANSACTION_ID

GEN_OBJECT_ID

ASSET_ID

ITEM_CLASS_CODE

ITEM_CLASS_NAME

ITEM_ID

ITEM_NUMBER

ITEM_DESCRIPTION

PRIMARY_UOM_CODE

SERIAL_NUMBER

LOT_NUMBER

ASSET_QUANTITY

CURRENT_LOCATION_CONTEXT

CURRENT_ORGANIZATION_ID

CURRENT_SUBINVENTORY_CODE

CURRENT_LOCATOR_ID

CURRENT_WORK_ORDER_ID

CURRENT_WO_OPERATION_ID

CURRENT_WORK_CENTER_ID

CURRENT_CUSTOMER_ID

CURRENT_CUSTOMER_SITE_ID

SHIPMENT_DATE

PURCHASE_DATE

Query

SQL_Statement

select ctor.tracked_object_ref_id tracked_object_ref_id,

ctor.tracked_object_code tracked_object_code,

cto.data_source_type data_source_type,

cto.data_source data_source,

cto.pk_attribute1 pk_attribute1,

ctor.pk_value1 pk_value1,

cto.uk_attribute1 uk_attribute1,

ctor.uk_value1 uk_value1,

cto.pk_attribute2 pk_attribute2,

ctor.pk_value2 pk_value2,

cto.uk_attribute2 uk_attribute2,

ctor.uk_value2 uk_value2,

cto.pk_attribute3 pk_attribute3,

ctor.pk_value3 pk_value3,

cto.uk_attribute3 uk_attribute3,

ctor.uk_value3 uk_value3,

cto.pk_attribute4 pk_attribute4,

ctor.pk_value4 pk_value4,

cto.uk_attribute4 uk_attribute4,

ctor.uk_value4 uk_value4,

ct.src_transaction_date src_transaction_date,

ct.transaction_id transaction_id,

ctor.gen_object_id gen_object_id,

cab.asset_id asset_id,

eic.item_class_code item_class_code,

eic.item_class_name item_class_name,

cab.item_id item_id,

esi.item_number item_number,

esi.description item_description,

esi.primary_uom_code primary_uom_code,

cab.serial_number serial_number,

cab.lot_number lot_number,

cab.quantity asset_quantity,

cab.current_location_context current_location_context,

cab.item_organization_id current_organization_id,

cab.subinventory_code current_subinventory_code,

cab.inventory_locator_id current_locator_id,

cab.work_order_id current_work_order_id,

cab.work_order_operation_id current_wo_operation_id,

cab.work_center_id current_work_center_id,

cab.customer_id current_customer_id,

cab.customer_site_id current_customer_site_id,

cab.shipment_date shipment_date,

cab.purchase_date purchase_date

from cse_assets_b cab,

cse_tracked_object_refs ctor,

cse_transactions ct,

egp_system_items_vl esi,

egp_item_classes_vl eic,

cse_tracked_objects cto

where cab.asset_id = ctor.asset_id

and ct.transaction_id = ctor.transaction_id

and esi.inventory_item_id = cab.item_id

and esi.organization_id = cab.item_organization_id

and eic.item_class_id = esi.item_catalog_group_id

and cto.object_code = ctor.tracked_object_code