eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: XTR.XTR_PARTY_INFO#

Object Details

Object Name:	XTR_PARTY_INFO#
Object Type:	VIEW
Owner:	XTR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ACCOUNT_MANAGER	VARCHAR2	(10)
ACCOUNT_STATUS	VARCHAR2	(14)
ADDRESS_1	VARCHAR2	(50)
ADDRESS_2	VARCHAR2	(50)
ADDRESS_3	VARCHAR2	(50)
ADDRESS_4	VARCHAR2	(50)
ADDRESS_5	VARCHAR2	(50)
ADDRESS_6	VARCHAR2	(50)
ADVISOR_YN	VARCHAR2	(1)
AUDIT_INDICATOR	VARCHAR2	(1)
AUTHORISED	VARCHAR2	(1)
BRANCH_SUBSIDIARY_CODE	VARCHAR2	(7)
BRANCH_SUBSIDIARY_YN	VARCHAR2	(1)
BROKER	VARCHAR2	(1)
BROKERAGE_CATEGORY	VARCHAR2	(7)
CLIENT_ADVICE	VARCHAR2	(1)
CLIENT_AGENT1	VARCHAR2	(20)
CLIENT_AGENT2	VARCHAR2	(20)
CLIENT_AGENT3	VARCHAR2	(20)
CLIENT_GROUPING	VARCHAR2	(7)
CLIENT_YN	VARCHAR2	(1)
COMMENTS	VARCHAR2	(255)
CONFO_ACTION_CODE	VARCHAR2	(20)
CONFO_GROUP_CODE	VARCHAR2	(20)
CONTACT_NAME	VARCHAR2	(50)
COUNTRY_CODE	VARCHAR2	(2)
CREATED_BY	VARCHAR2	(30)	Yes
CREATED_ON	DATE		Yes
CROSS_REF_TO_OTHER_PARTY	VARCHAR2	(7)
DEFAULT_ADDRESS_DETAILS	VARCHAR2	(1)
DEFAULT_COMPANY	VARCHAR2	(1)
DEPOSIT_REF	VARCHAR2	(10)
EMAIL_ADDRESS	VARCHAR2	(40)
FAX_NUMBER	VARCHAR2	(15)
FULL_NAME	VARCHAR2	(50)	Yes
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)
PI_CONSTANT	VARCHAR2	(1)
P_ADDRESS_1	VARCHAR2	(50)
P_ADDRESS_2	VARCHAR2	(50)
P_ADDRESS_3	VARCHAR2	(50)
P_ADDRESS_4	VARCHAR2	(50)
RISK_PARTY	VARCHAR2	(1)
SETTLEMENT_DEFAULT_CATEGORY	VARCHAR2	(7)
SHORT_NAME	VARCHAR2	(20)	Yes
STATE_CODE	VARCHAR2	(3)
SWIFT_ID	VARCHAR2	(11)
TAX_CATEGORY	VARCHAR2	(7)
TAX_EXEMPTION_CODE	VARCHAR2	(15)
TAX_NUMBER	VARCHAR2	(20)
TITLE_DESCRIPTION	VARCHAR2	(50)
UPDATED_BY	VARCHAR2	(30)
UPDATED_ON	DATE
VALUER_YN	VARCHAR2	(1)
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)
EM_CPARTY	VARCHAR2	(1)
CE_BANK_BRANCH_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_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
,      EM_CPARTY
,      CE_BANK_BRANCH_ID
FROM XTR.XTR_PARTY_INFO#;

Dependencies

[top of page]

XTR.XTR_PARTY_INFO# references the following:

XTR: XTR_PARTY_INFO

XTR.XTR_PARTY_INFO# is referenced by following:

APPS: XTR_AU_PARTY_INFO_T; XTR_PARTY_INFO