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


VIEW: APPS.XLE_FIRSTPARTY_INFORMATION_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGAL_ENTITY_ID NUMBER (15) Yes
LE_INFORMATION_CONTEXT VARCHAR2 (30)
NAME VARCHAR2 (240) Yes
PARTY_ID NUMBER (15) Yes
LEGAL_ENTITY_IDENTIFIER VARCHAR2 (30)
ACTIVITY_CODE VARCHAR2 (150)
SUB_ACTIVITY_CODE VARCHAR2 (150)
TYPE_OF_COMPANY VARCHAR2 (50)
ACTIVITY_CATEGORY VARCHAR2 (60)
ACTIVITY_DESCRIPTION VARCHAR2 (80)
LE_EFFECTIVE_FROM DATE

LE_EFFECTIVE_TO DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
GEOGRAPHY_ID NUMBER (15) Yes
REGISTRATION_NUMBER VARCHAR2 (30) Yes
LEGISLATIVE_CAT_CODE VARCHAR2 (30) Yes
EFFECTIVE_FROM DATE

EFFECTIVE_TO DATE

LOCATION_ID NUMBER (15)
ADDRESS_STYLE VARCHAR2 (7)
ADDRESS_LINE_1 VARCHAR2 (240)
ADDRESS_LINE_2 VARCHAR2 (240)
ADDRESS_LINE_3 VARCHAR2 (240)
TOWN_OR_CITY VARCHAR2 (30)
REGION_1 VARCHAR2 (120)
REGION_2 VARCHAR2 (120)
REGION_3 VARCHAR2 (120)
POSTAL_CODE VARCHAR2 (30)
COUNTRY VARCHAR2 (60)
Query Text

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


SELECT LEGAL_ENTITY_ID
,      LE_INFORMATION_CONTEXT
,      NAME
,      PARTY_ID
,      LEGAL_ENTITY_IDENTIFIER
,      ACTIVITY_CODE
,      SUB_ACTIVITY_CODE
,      TYPE_OF_COMPANY
,      ACTIVITY_CATEGORY
,      ACTIVITY_DESCRIPTION
,      LE_EFFECTIVE_FROM
,      LE_EFFECTIVE_TO
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GEOGRAPHY_ID
,      REGISTRATION_NUMBER
,      LEGISLATIVE_CAT_CODE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      LOCATION_ID
,      ADDRESS_STYLE
,      ADDRESS_LINE_1
,      ADDRESS_LINE_2
,      ADDRESS_LINE_3
,      TOWN_OR_CITY
,      REGION_1
,      REGION_2
,      REGION_3
,      POSTAL_CODE
,      COUNTRY
FROM APPS.XLE_FIRSTPARTY_INFORMATION_V;

Dependencies

[top of page]

APPS.XLE_FIRSTPARTY_INFORMATION_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
SynonymFND_DESCR_FLEX_COLUMN_USAGES
SynonymFND_FLEX_VALUE_SETS
SynonymHR_LOCATIONS_ALL
SynonymXLE_ENTITY_PROFILES
SynonymXLE_JURISDICTIONS_B
SynonymXLE_REGISTRATIONS
APPS.XLE_FIRSTPARTY_INFORMATION_V is referenced by following:

SchemaAPPS
ViewARBPA_CUSTOMER_TRX_HEADER
Package BodyARP_CHARGEBACK_COVER - show dependent code
Package BodyBOM_CSTGILEV_XMLP_PKG - show dependent code
Package BodyBOM_CSTRACCR_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPACQ_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPDSS_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPICR_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPMDD_XMLP_PKG - show dependent code
Package BodyBOM_CSTRPWRO_XMLP_PKG - show dependent code
ViewCE_FC_AMTS_DISC_V
ViewCE_FC_BANK_BAL_DISC_V
ViewCE_XLA_EXT_HEADERS_V
ViewCSTBV_LE_COST_TYPES
ViewCSTFV_COST_GROUPS
ViewCSTFV_LE_COST_TYPES
ViewCSTFV_PAC_PERIODS
Package BodyCSTPMRGL - show dependent code
Package BodyCST_EAM_WORKORDERS_PVT - show dependent code
ViewCST_LE_COST_TYPES_V
ViewCST_MGD_LIFO_ITEM_COSTS_V
ViewCST_MGD_LIFO_PERIODS_V
ViewCST_MTL_RCV_TXN_V
ViewCST_PAC_LEGAL_ENTITIES_V
ViewCST_PAC_WIP_TXN_V
Package BodyFUN_BAL_UTILS_GRP - show dependent code
Package BodyFUN_IC_AME_WF_PKG - show dependent code
Package BodyFUN_OPEN_INTERFACE_PKG - show dependent code
Package BodyFUN_TCA_PKG - show dependent code
Package BodyFUN_TRX_ENTRY_UTIL - show dependent code
Package BodyFUN_TRX_PUB - show dependent code
Package BodyFUN_TRX_PVT - show dependent code
Package BodyFUN_WEBADI_PKG - show dependent code
ViewFV_SYSTEM_PARAMETERS_V
Package BodyIBY_DISBURSEMENT_COMP_PUB - show dependent code
PL/SQL PackageIBY_DISBURSEMENT_COMP_PUB - show dependent code
Package BodyIBY_EXTRACTGEN_PVT - show dependent code
ViewIBY_EXT_FD_PAYER_1_0_V
Package BodyIBY_FD_EXTRACT_GEN_PVT - show dependent code
Package BodyIBY_FD_USER_API_PUB - show dependent code
Package BodyIBY_FNDCPT_VLD_PUB - show dependent code
Package BodyIBY_PAYGROUP_PUB - show dependent code
ViewIBY_PP_FIRST_PARTY_V
Package BodyINV_MGD_MVT_UTILS_PKG - show dependent code
Package BodyJE_ES_WHTAX - show dependent code
Package BodyJE_JEITAPEX_XMLP_PKG - show dependent code
Package BodyJE_JEITXLRG_XMLP_PKG - show dependent code
Package BodyJG_JGZZARIN_XMLP_PKG - show dependent code
Package BodyJG_JGZZGLJRB_XMLP_PKG - show dependent code
Package BodyJG_JGZZGLJRN_XMLP_PKG - show dependent code
Package BodyJG_JGZZRCAK_XMLP_PKG - show dependent code
Package BodyJG_ZZ_PTCE_DT_PKG - show dependent code
PL/SQL PackageJG_ZZ_RTCE_DT_PKG - show dependent code
Package BodyJG_ZZ_RTCE_DT_PKG - show dependent code
Package BodyJG_ZZ_SUMMARY_ALL_PKG - show dependent code
Package BodyJG_ZZ_TURNOVER_AR_PKG - show dependent code
Package BodyJG_ZZ_VAT_PRE_REP_PROC_PKG - show dependent code
Package BodyJG_ZZ_VAT_SELECTION_PKG - show dependent code
Package BodyJL_AR_DOC_NUMBERING_PKG - show dependent code
Package BodyJL_CO_GL_MG_MEDIA_PKG - show dependent code
Package BodyJL_JGZZGLTRB_XMLP_PKG - show dependent code
Package BodyJL_JLCLGCAL_XMLP_PKG - show dependent code
Package BodyJL_JLCOARCR_XMLP_PKG - show dependent code
Package BodyJL_JLCOGLAM_XMLP_PKG - show dependent code
Package BodyJL_JLCOGLAN_XMLP_PKG - show dependent code
Package BodyJL_JLCOGLNA_XMLP_PKG - show dependent code
Package BodyJL_JLCOGLNM_XMLP_PKG - show dependent code
Package BodyJL_JLZZPSSR_XMLP_PKG - show dependent code
Package BodyLNS_REP_UTILS - show dependent code
ViewMTL_FISCAL_CAT_ACCOUNTS_V
ViewMTL_LE_ECONOMIC_ZONES_V
ViewMTL_STAT_TYPE_USAGES_V
ViewPA_VRM_SOURCE_DOCUMENT
ViewPA_VRM_SOURCE_DOC_SUB_LINES
Package BodyXLE_UTILITIES_GRP - show dependent code
Package BodyZX_DEFAULT_AUTOMATION_PKG - show dependent code
Package BodyZX_EXTRACT_PKG - show dependent code
Package BodyZX_TCM_CONTROL_PKG - show dependent code
ViewZX_TRL_ESL_VAT_NO_V
Package BodyZX_VALIDATE_API_PKG - show dependent code