[Home] [Help]
[Dependency Information]
VIEW: APPS.XLE_FIRSTPARTY_INFORMATION_V
Object Details
[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:
-
APPS
-
AR_LOOKUPS
-
FND_DESCR_FLEX_COLUMN_USAGES
-
FND_FLEX_VALUE_SETS
-
HR_LOCATIONS_ALL
-
XLE_ENTITY_PROFILES
-
XLE_JURISDICTIONS_B
-
XLE_REGISTRATIONS
APPS.XLE_FIRSTPARTY_INFORMATION_V is referenced by following:
-
APPS
-
ARBPA_CUSTOMER_TRX_HEADER
-
ARP_CHARGEBACK_COVER
- show dependent code
-
BOM_CSTGILEV_XMLP_PKG
- show dependent code
-
BOM_CSTRACCR_XMLP_PKG
- show dependent code
-
BOM_CSTRPACQ_XMLP_PKG
- show dependent code
-
BOM_CSTRPDSS_XMLP_PKG
- show dependent code
-
BOM_CSTRPICR_XMLP_PKG
- show dependent code
-
BOM_CSTRPMDD_XMLP_PKG
- show dependent code
-
BOM_CSTRPWRO_XMLP_PKG
- show dependent code
-
CE_FC_AMTS_DISC_V
-
CE_FC_BANK_BAL_DISC_V
-
CE_XLA_EXT_HEADERS_V
-
CSTBV_LE_COST_TYPES
-
CSTFV_COST_GROUPS
-
CSTFV_LE_COST_TYPES
-
CSTFV_PAC_PERIODS
-
CSTPMRGL
- show dependent code
-
CST_EAM_WORKORDERS_PVT
- show dependent code
-
CST_LE_COST_TYPES_V
-
CST_MGD_LIFO_ITEM_COSTS_V
-
CST_MGD_LIFO_PERIODS_V
-
CST_MTL_RCV_TXN_V
-
CST_PAC_LEGAL_ENTITIES_V
-
CST_PAC_WIP_TXN_V
-
FUN_BAL_UTILS_GRP
- show dependent code
-
FUN_IC_AME_WF_PKG
- show dependent code
-
FUN_OPEN_INTERFACE_PKG
- show dependent code
-
FUN_TCA_PKG
- show dependent code
-
FUN_TRX_ENTRY_UTIL
- show dependent code
-
FUN_TRX_PUB
- show dependent code
-
FUN_TRX_PVT
- show dependent code
-
FUN_WEBADI_PKG
- show dependent code
-
FV_SYSTEM_PARAMETERS_V
-
IBY_DISBURSEMENT_COMP_PUB
- show dependent code
-
IBY_DISBURSEMENT_COMP_PUB
- show dependent code
-
IBY_EXTRACTGEN_PVT
- show dependent code
-
IBY_EXT_FD_PAYER_1_0_V
-
IBY_FD_EXTRACT_GEN_PVT
- show dependent code
-
IBY_FD_USER_API_PUB
- show dependent code
-
IBY_FNDCPT_VLD_PUB
- show dependent code
-
IBY_PAYGROUP_PUB
- show dependent code
-
IBY_PP_FIRST_PARTY_V
-
INV_MGD_MVT_UTILS_PKG
- show dependent code
-
JE_ES_WHTAX
- show dependent code
-
JE_JEITAPEX_XMLP_PKG
- show dependent code
-
JE_JEITXLRG_XMLP_PKG
- show dependent code
-
JG_JGZZARIN_XMLP_PKG
- show dependent code
-
JG_JGZZGLJRB_XMLP_PKG
- show dependent code
-
JG_JGZZGLJRN_XMLP_PKG
- show dependent code
-
JG_JGZZRCAK_XMLP_PKG
- show dependent code
-
JG_ZZ_PTCE_DT_PKG
- show dependent code
-
JG_ZZ_RTCE_DT_PKG
- show dependent code
-
JG_ZZ_RTCE_DT_PKG
- show dependent code
-
JG_ZZ_SUMMARY_ALL_PKG
- show dependent code
-
JG_ZZ_TURNOVER_AR_PKG
- show dependent code
-
JG_ZZ_VAT_PRE_REP_PROC_PKG
- show dependent code
-
JG_ZZ_VAT_SELECTION_PKG
- show dependent code
-
JL_AR_DOC_NUMBERING_PKG
- show dependent code
-
JL_CO_GL_MG_MEDIA_PKG
- show dependent code
-
JL_JGZZGLTRB_XMLP_PKG
- show dependent code
-
JL_JLCLGCAL_XMLP_PKG
- show dependent code
-
JL_JLCOARCR_XMLP_PKG
- show dependent code
-
JL_JLCOGLAM_XMLP_PKG
- show dependent code
-
JL_JLCOGLAN_XMLP_PKG
- show dependent code
-
JL_JLCOGLNA_XMLP_PKG
- show dependent code
-
JL_JLCOGLNM_XMLP_PKG
- show dependent code
-
JL_JLZZPSSR_XMLP_PKG
- show dependent code
-
LNS_REP_UTILS
- show dependent code
-
MTL_FISCAL_CAT_ACCOUNTS_V
-
MTL_LE_ECONOMIC_ZONES_V
-
MTL_STAT_TYPE_USAGES_V
-
PA_VRM_SOURCE_DOCUMENT
-
PA_VRM_SOURCE_DOC_SUB_LINES
-
XLE_UTILITIES_GRP
- show dependent code
-
ZX_DEFAULT_AUTOMATION_PKG
- show dependent code
-
ZX_EXTRACT_PKG
- show dependent code
-
ZX_TCM_CONTROL_PKG
- show dependent code
-
ZX_TRL_ESL_VAT_NO_V
-
ZX_VALIDATE_API_PKG
- show dependent code