XLE_BSV_ASSOCIATIONS

Details

• Schema: FUSION

• Object owner: XLE

• Object type: VIEW

Columns

Name
CONTEXT ENTITY_TYPE LEGAL_CONSTRUCT ASSOCIATION_TYPE_ID ASSOCIATION_ID ENTITY_ID ENTITY_NAME LEGAL_CONSTRUCT_ID LEGAL_PARTY_ID LEGAL_CONSTRUCT_NAME LEGAL_PARENT_ID EFFECTIVE_FROM EFFECTIVE_TO

Query

SQL_Statement

SELECT assoc_types.CONTEXT, assoc_obj.NAME Entity_Type, assoc_subj.NAME Legal_Construct, assoc_types.ASSOCIATION_TYPE_ID, assoc.ASSOCIATION_ID, assoc.OBJECT_ID Entity_Id, flex_val.FLEX_VALUE Entity_Name, assoc.SUBJECT_ID Legal_Construct_Id, xep.party_id Legal_Party_Id, xep.name Legal_Construct_Name, assoc.SUBJECT_PARENT_ID Legal_Parent_Id, assoc.EFFECTIVE_FROM, assoc.EFFECTIVE_TO FROM XLE_ASSOC_OBJECT_TYPES assoc_obj, XLE_ASSOC_OBJECT_TYPES assoc_subj, XLE_ASSOCIATION_TYPES assoc_types, XLE_ASSOCIATIONS assoc, FND_FLEX_VALUES flex_val, XLE_ETB_PROFILES xep WHERE assoc_obj.OBJECT_TYPE_ID = assoc_types.OBJECT_TYPE_ID AND assoc_subj.OBJECT_TYPE_ID = assoc_types.SUBJECT_TYPE_ID AND assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID AND flex_val.flex_value_id = assoc.object_id AND assoc_types.context = 'EST_BSV_MAPPING' AND assoc.subject_id = xep.establishment_id