XLE_ASSOCIATIONS_V

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, ent_prof.name 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, XLE_ENTITY_PROFILES ent_prof, xle_entity_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 ent_prof.legal_entity_id = assoc.object_id AND assoc_obj.NAME = 'LEGAL_ENTITY' AND assoc.SUBJECT_ID = xep.legal_entity_id UNION 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, org.name 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, HR_ALL_ORGANIZATION_UNITS org, 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 org.organization_id = assoc.object_id AND assoc_obj.NAME = 'OPERATING_UNIT' AND assoc.SUBJECT_ID = xep.establishment_id UNION 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, OOD.organization_name 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, INV_ORGANIZATION_DEFINITIONS_V OOD, 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 OOD.organization_id = assoc.object_id AND assoc_obj.NAME = 'INVENTORY_ORGANIZATION' AND assoc.SUBJECT_ID = xep.establishment_id UNION 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, hr_loc.LOCATION_CODE 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, HR_LOCATIONS hr_loc, 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 hr_loc.location_id = assoc.object_id AND assoc_obj.NAME in ('INVENTORY_LOCATION','SHIP_TO_LOCATION','BILL_TO_LOCATION') AND assoc.SUBJECT_ID = xep.establishment_id UNION 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_obj.NAME = 'BALANCING_SEGMENT_VALUE' AND assoc.SUBJECT_ID = xep.establishment_id