VIEW: APPS.XLE_TAX_ASSOCIATIONS

Source

View Text - Preformatted

(
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
	)

View Text - HTML Formatted

( 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 )