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

TABLE: XTR.XTR_A_PARTY_INFO

Object Details
Object Name: XTR_A_PARTY_INFO
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_A_PARTY_INFO
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_A_PARTY_INFO_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUPDATED_ON
XTR_A_PARTY_INFO_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_CODE
Columns
Name Datatype Length Mandatory Comments
ACCOUNT_MANAGER VARCHAR2 (20)
ACCOUNT_STATUS VARCHAR2 (14)
ADDRESS_1 VARCHAR2 (50)
Name of addressee.
ADDRESS_2 VARCHAR2 (50)
Postal address line 2.
ADDRESS_3 VARCHAR2 (50)
Postal address line 3.
ADDRESS_4 VARCHAR2 (50)
Postal address line 4.
ADDRESS_5 VARCHAR2 (50)
Postal address line 5.
ADDRESS_6 VARCHAR2 (50)
Postal address line 6.
ADVISOR_YN VARCHAR2 (1)
Indicates if the party is an advisor. Valid values are: Y (is an advisor) or N (not an advisor).
AUDIT_DATE_STORED DATE

Date on which this record is audited.
AUDIT_INDICATOR VARCHAR2 (1)
AUTHORISED VARCHAR2 (1)
Indicates if this record is authorised to be used. Valid values are: Y (authorised) or N (not authorised).
BRANCH_SUBSIDIARY_CODE VARCHAR2 (7)
BRANCH_SUBSIDIARY_YN VARCHAR2 (1)
BROKER VARCHAR2 (1)
BROKERAGE_CATEGORY VARCHAR2 (7)
Brokerage category identifier. Foreign key to XTR_BROKERAGE_CATEGORIES.
CLIENT_ADVICE VARCHAR2 (1)
Indicates if confirmation advice letter is required for the party's confirmation actions. Valid values are: Y (requried) or N (not requried).
CLIENT_AGENT1 VARCHAR2 (20)
Name of the party's solicitor.
CLIENT_AGENT2 VARCHAR2 (20)
Name of the party's accountant.
CLIENT_AGENT3 VARCHAR2 (20)
Name of any other agent of the party.
CLIENT_GROUPING VARCHAR2 (7)
Client group identifier. Foreign key to XTR_PARTY_GROUPS.
CLIENT_YN VARCHAR2 (1)
Indicates if the party is a client. Valid values are: Y (is a client) or N (not a client).
COMMENTS VARCHAR2 (255)
Additional note.
CONFO_ACTION_CODE VARCHAR2 (20)
CONFO_GROUP_CODE VARCHAR2 (20)
Confirmation group identifer. Composite key to XTR_CONFIRMATION_ACTIONS.
CONTACT_NAME VARCHAR2 (50)
COUNTRY_CODE VARCHAR2 (2)
Country identifier. Foreign key to XTR_COUNTRY_CODES.
CREATED_BY VARCHAR2 (30) Yes User who created this record.
CREATED_ON DATE
Yes Date on which this record is created.
CROSS_REF_TO_OTHER_PARTY VARCHAR2 (7)
DEFAULT_ADDRESS_DETAILS VARCHAR2 (1)
DEFAULT_COMPANY VARCHAR2 (1)
DEPOSIT_REF VARCHAR2 (10)
EMAIL_ADDRESS VARCHAR2 (40)
Party's email address.
FAX_NUMBER VARCHAR2 (15)
Party's fax number.
FULL_NAME VARCHAR2 (50) Yes Full name of the party.
FX_MATCH_ID VARCHAR2 (11)
INTERNAL_PTY VARCHAR2 (1)
PAGER_NUMBER NUMBER

PARTY_CATEGORY VARCHAR2 (2)
PARTY_CODE VARCHAR2 (7) Yes
PARTY_GROUP VARCHAR2 (7)
PARTY_TYPE VARCHAR2 (2) Yes
PHONE_NUMBER VARCHAR2 (15)
Party's contact phone number.
PI_CONSTANT VARCHAR2 (1)
P_ADDRESS_1 VARCHAR2 (50)
Physical address line 1.
P_ADDRESS_2 VARCHAR2 (50)
Physical address line 2.
P_ADDRESS_3 VARCHAR2 (50)
Physical address line 3.
P_ADDRESS_4 VARCHAR2 (50)
Physical address line 4.
RISK_PARTY VARCHAR2 (1)
Indicates if the party is a risk party. Valid values are: Y (is a risk party) or N (not a risk party).
SETTLEMENT_DEFAULT_CATEGORY VARCHAR2 (7)
Settlement default category. Foreign key to XTR_SETTLEMENT_CATEGORIES.
SHORT_NAME VARCHAR2 (20) Yes Short name of the party.
STATE_CODE VARCHAR2 (3)
State identifier. Free text.
SWIFT_ID VARCHAR2 (11)
TAX_CATEGORY VARCHAR2 (7)
Tax category idnetifier. Foreign key to XTR_TAX_CATEGORIES.
TAX_EXEMPTION_CODE VARCHAR2 (15)
Tax exemption identifier. Free text.
TAX_NUMBER VARCHAR2 (20)
TITLE_DESCRIPTION VARCHAR2 (50)
Title description. Free text.
UPDATED_BY VARCHAR2 (30)
Last updated user.
UPDATED_ON DATE

Last updated date.
VALUER_YN VARCHAR2 (1)
Indicates if the party is a valuer. Valid values are: Y (is a valuer) or N (not a valuer).
FX_CPARTY VARCHAR2 (1)
MM_CPARTY VARCHAR2 (1)
LEGAL_ENTITY_ID NUMBER (15)
SUSPENSE_CCID NUMBER (15)
CONVERSION_TYPE VARCHAR2 (30)
SET_OF_BOOKS_ID NUMBER (15)
CHART_OF_ACCOUNTS_ID NUMBER (15)
Query Text

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


SELECT ACCOUNT_MANAGER
,      ACCOUNT_STATUS
,      ADDRESS_1
,      ADDRESS_2
,      ADDRESS_3
,      ADDRESS_4
,      ADDRESS_5
,      ADDRESS_6
,      ADVISOR_YN
,      AUDIT_DATE_STORED
,      AUDIT_INDICATOR
,      AUTHORISED
,      BRANCH_SUBSIDIARY_CODE
,      BRANCH_SUBSIDIARY_YN
,      BROKER
,      BROKERAGE_CATEGORY
,      CLIENT_ADVICE
,      CLIENT_AGENT1
,      CLIENT_AGENT2
,      CLIENT_AGENT3
,      CLIENT_GROUPING
,      CLIENT_YN
,      COMMENTS
,      CONFO_ACTION_CODE
,      CONFO_GROUP_CODE
,      CONTACT_NAME
,      COUNTRY_CODE
,      CREATED_BY
,      CREATED_ON
,      CROSS_REF_TO_OTHER_PARTY
,      DEFAULT_ADDRESS_DETAILS
,      DEFAULT_COMPANY
,      DEPOSIT_REF
,      EMAIL_ADDRESS
,      FAX_NUMBER
,      FULL_NAME
,      FX_MATCH_ID
,      INTERNAL_PTY
,      PAGER_NUMBER
,      PARTY_CATEGORY
,      PARTY_CODE
,      PARTY_GROUP
,      PARTY_TYPE
,      PHONE_NUMBER
,      PI_CONSTANT
,      P_ADDRESS_1
,      P_ADDRESS_2
,      P_ADDRESS_3
,      P_ADDRESS_4
,      RISK_PARTY
,      SETTLEMENT_DEFAULT_CATEGORY
,      SHORT_NAME
,      STATE_CODE
,      SWIFT_ID
,      TAX_CATEGORY
,      TAX_EXEMPTION_CODE
,      TAX_NUMBER
,      TITLE_DESCRIPTION
,      UPDATED_BY
,      UPDATED_ON
,      VALUER_YN
,      FX_CPARTY
,      MM_CPARTY
,      LEGAL_ENTITY_ID
,      SUSPENSE_CCID
,      CONVERSION_TYPE
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
FROM XTR.XTR_A_PARTY_INFO;

Dependencies

[top of page]

XTR.XTR_A_PARTY_INFO does not reference any database object

XTR.XTR_A_PARTY_INFO is referenced by following:

SchemaAPPS
SynonymXTR_A_PARTY_INFO