XLE_TAX_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, decode(assoc_obj.NAME, 'INVENTORY_ORGANIZATION',org.name,'OPERATING_UNIT',org.name,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, HR_ALL_ORGANIZATION_UNITS org 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 org.organization_id(+) = assoc.object_id AND assoc_types.CONTEXT = 'TAX_CALCULATION' AND xep.establishment_id = assoc.SUBJECT_ID )