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

VIEW: APPS.XLE_LEGALAUTH_V

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

XLE_LEGALAUTH_V view provides the list of Legal Authorities.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LEGALAUTH_ID NUMBER (15) Yes Legal Authority Identifier
AUTHORITY_NAME VARCHAR2 (360) Yes Legal Authority Name
ADDRESS_STYLE VARCHAR2 (30)
Address Style
ADDRESS1 VARCHAR2 (240) Yes Address1
ADDRESS2 VARCHAR2 (240)
Address2
ADDRESS3 VARCHAR2 (240)
Address3
ADDRESS4 VARCHAR2 (240)
Address4
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
POSTAL_CODE VARCHAR2 (60)
Postal Code
COUNTRY VARCHAR2 (60) Yes Country
PARTY_ID NUMBER (15) Yes Party id of the Legal Authority
PARTY_SITE_ID NUMBER (15) Yes Party Site id of the Legal Authority
LEGISLATIVE_CATEGORY_CODE VARCHAR2 (30)
Legislative Category of the Legal Authority. Ex: - Income Tax
Query Text

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


SELECT LEGALAUTH_ID
,      AUTHORITY_NAME
,      ADDRESS_STYLE
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      STATE
,      POSTAL_CODE
,      COUNTRY
,      PARTY_ID
,      PARTY_SITE_ID
,      LEGISLATIVE_CATEGORY_CODE
FROM APPS.XLE_LEGALAUTH_V;

Dependencies

[top of page]

APPS.XLE_LEGALAUTH_V references the following:

SchemaAPPS
SynonymHZ_CODE_ASSIGNMENTS
SynonymHZ_LOCATIONS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
APPS.XLE_LEGALAUTH_V is referenced by following:

SchemaAPPS
ViewARBPA_CUSTOMER_TRX_HEADER
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 BodyZX_EXTRACT_PKG - show dependent code