1. Tables and Views for SCM
  2. CSE_GENEALOGY_OBJ_NODES_V

CSE_GENEALOGY_OBJ_NODES_V

Details

  • Schema: FUSION

  • Object owner: CSE

  • Object type: VIEW

Columns

Name

TRACKED_LEVEL

PARENT_OBJECT_CODE

PARENT_OBJECT_CODE_MEANING

OBJECT_CODE

OBJECT_CODE_MEANING

DATA_SOURCE_TYPE

DATA_SOURCE

PK_ATTRIBUTE1

UK_ATTRIBUTE1

PK_ATTRIBUTE2

UK_ATTRIBUTE2

PK_ATTRIBUTE3

UK_ATTRIBUTE3

PK_ATTRIBUTE4

UK_ATTRIBUTE4

PK_ATTRIBUTE5

UK_ATTRIBUTE5

DISPLAY_ATTRIBUTE1

DISPLAY_ATTRIBUTE2

DISPLAY_ATTRIBUTE3

DISPLAY_ATTRIBUTE4

DISPLAY_ATTRIBUTE5

INV_TXN_SOURCE_TYPE_ID

INV_TXN_SOURCE_TYPE_NAME

Query

SQL_Statement

select tracked_obj.tracked_level tracked_level,

tracked_obj.parent_object_code parent_object_code,

po_lk.meaning parent_object_code_meaning,

tracked_obj.object_code object_code,

co_lk.meaning object_code_meaning,

tracked_obj.data_source_type data_source_type,

tracked_obj.data_source data_source,

tracked_obj.pk_attribute1 pk_attribute1,

tracked_obj.uk_attribute1 uk_attribute1,

tracked_obj.pk_attribute2 pk_attribute2,

tracked_obj.uk_attribute2 uk_attribute2,

tracked_obj.pk_attribute3 pk_attribute3,

tracked_obj.uk_attribute3 uk_attribute3,

tracked_obj.pk_attribute4 pk_attribute4,

tracked_obj.uk_attribute4 uk_attribute4,

tracked_obj.pk_attribute5 pk_attribute5,

tracked_obj.uk_attribute5 uk_attribute5,

tracked_obj.display_attribute1 display_attribute1,

tracked_obj.display_attribute2 display_attribute2,

tracked_obj.display_attribute3 display_attribute3,

tracked_obj.display_attribute4 display_attribute4,

tracked_obj.display_attribute5 display_attribute5,

tracked_obj.inv_txn_source_type_id inv_txn_source_type_id,

itst.transaction_source_type_name inv_txn_source_type_name

from (select level tracked_level,

parent_object_code,

object_code,

data_source_type,

data_source,

pk_attribute1,

pk_attribute2,

pk_attribute3,

pk_attribute4,

pk_attribute5,

uk_attribute1,

uk_attribute2,

uk_attribute3,

uk_attribute4,

uk_attribute5,

display_attribute1,

display_attribute2,

display_attribute3,

display_attribute4,

display_attribute5,

inv_txn_source_type_id

from cse_tracked_objects

start with parent_object_code is not null

connect by prior object_code = parent_object_code) tracked_obj,

fnd_lookup_values po_lk,

fnd_lookup_values co_lk,

inv_txn_source_types_vl itst

where po_lk.lookup_type = 'ORA_CSE_TRACKED_OBJECT'

and po_lk.lookup_code = tracked_obj.parent_object_code

and co_lk.lookup_type = 'ORA_CSE_TRACKED_OBJECT'

and co_lk.lookup_code = tracked_obj.object_code

and itst.transaction_source_type_id(+) = tracked_obj.inv_txn_source_type_id