[Home] [Help]
[Dependency Information]
| Object Name: | XLE_FIRSTPARTY_INFORMATION_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XLE.XLE_FIRSTPARTY_INFORMATION_V
|
| Subobject Name: | |
| Status: | VALID |
| 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) |
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;
APPS
AR_LOOKUPS
FND_DESCR_FLEX_COLUMN_USAGES
FND_FLEX_VALUE_SETS
HR_LOCATIONS_ALL
XLE_ENTITY_PROFILES
XLE_JURISDICTIONS_B
XLE_REGISTRATIONS
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
|
|
|
|