[Home] [Help]
View: XLE_TAX_ASSOCIATIONS
View Text
(
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_ALL 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
)