View: XLE_BSV_ASSOCIATIONS

Product:	XLE - Legal Entity Configurator
Description:
Implementation/DBA Data:	APPS.XLE_BSV_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
, 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