DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.XLE_BSV_ASSOCIATIONS

Object Details
Object Name: XLE_BSV_ASSOCIATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLE.XLE_BSV_ASSOCIATIONS
Subobject Name:
Status: VALID

XLE_BSV_ASSOCIATIONS view retrieves the balancing segment value associations.

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTEXT VARCHAR2 (80) Yes Context
ENTITY_TYPE VARCHAR2 (80) Yes Entity Type
LEGAL_CONSTRUCT VARCHAR2 (80) Yes Legal Construct
ASSOCIATION_TYPE_ID NUMBER (15) Yes Association Type Identifier
ASSOCIATION_ID NUMBER (15) Yes Association Identifier
ENTITY_ID NUMBER (15) Yes Entity Identifier
ENTITY_NAME VARCHAR2 (150) Yes Entity Name
LEGAL_CONSTRUCT_ID NUMBER (15) Yes Legal Construct Identifier
LEGAL_PARTY_ID NUMBER (15) Yes Legal Party Identifier
LEGAL_CONSTRUCT_NAME VARCHAR2 (240) Yes Legal Construct Name
LEGAL_PARENT_ID NUMBER (15)
Legal Parent Identifier
EFFECTIVE_FROM DATE
Yes Effective From
EFFECTIVE_TO DATE

Effective To
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.XLE_BSV_ASSOCIATIONS;

Dependencies

[top of page]

APPS.XLE_BSV_ASSOCIATIONS references the following:

SchemaAPPS
SynonymFND_FLEX_VALUES
SynonymXLE_ASSOCIATIONS
SynonymXLE_ASSOCIATION_TYPES
SynonymXLE_ASSOC_OBJECT_TYPES
SynonymXLE_ETB_PROFILES
APPS.XLE_BSV_ASSOCIATIONS is referenced by following:

SchemaAPPS
Package BodyJL_BR_AP_VALIDATE_COLLECTION - show dependent code
Package BodyJL_BR_AR_LOG_VALIDATION - show dependent code
Package BodyJL_BR_SPED_DATA_EXTRACT_PKG - show dependent code
Package BodyJL_BR_WORKDAY_CALENDAR - show dependent code
Package BodyJL_JLBRRCAD_XMLP_PKG - show dependent code
Package BodyJL_ZZ_AP_LIBRARY_1_PKG - show dependent code