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: APPS.XTR_PARTIES_V

Object Details

Object Name:	XTR_PARTIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	XTR.XTR_PARTIES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

XTR_PARTIES_V contains view information for your parties and counterparties. Each row corresponds to a party and contains the party?s contact information including the address, phone number, tax information, and whether or not the party is a counterparty. This view does not just display the information in the XTR_PARTY_INFO table. Instead, it combines XTR_PARTY_INFO with XTR_COMPANY_AUTHORITIES and limits the view to only the companies that you are authorized for. Treasury uses this view extensively to ensure company security.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_CODE	VARCHAR2	(7)	Yes	Party code
PARTY_TYPE	VARCHAR2	(2)	Yes	Indicates if the party is a company or a counterparty
SHORT_NAME	VARCHAR2	(20)	Yes	Counterparty short name
FULL_NAME	VARCHAR2	(50)	Yes	Full name of a party
CREATED_BY	VARCHAR2	(30)	Yes	User who created this record
CREATED_ON	DATE		Yes	Date this record was created
RISK_PARTY	VARCHAR2	(1)		Flag to determine if the party is a risk party (Y), or not (N)
DEFAULT_COMPANY	VARCHAR2	(1)		Flag to indicate if a company should be set as default (Y), or not (N)
UPDATED_BY	VARCHAR2	(30)		User who last updated this record
UPDATED_ON	DATE			Date this record was last updated
HOME_CURRENCY	VARCHAR2	(15)		Home Currency
CONTACT_NAME	VARCHAR2	(50)		Name of the contact party for a deal
PHONE_NUMBER	VARCHAR2	(15)		Phone number of party
FAX_NUMBER	VARCHAR2	(15)		Fax number of a party
ADDRESS_1	VARCHAR2	(50)		(Cparty) contact name or (company) address line 1
ADDRESS_2	VARCHAR2	(50)		(Cparty) mailing address line 1 or (company) address line 2
ADDRESS_3	VARCHAR2	(50)		(Cparty) mailing address line 2 or (company) address line 3
ADDRESS_4	VARCHAR2	(50)		(Cparty) mailing address line 2 or (company) address line 3
ADDRESS_5	VARCHAR2	(50)		(Cparty) mailing address line 4 or (company) address line 5
ADDRESS_6	VARCHAR2	(50)		(Cparty) mailing address line 5 or (company) address line 6
COUNTRY_CODE	VARCHAR2	(2)		Country code
AUTHORISED	VARCHAR2	(1)		Flag to indicate if the party is authorized (Y), or not (N). Companies are always authorized
TAX_NUMBER	VARCHAR2	(20)		Number under which the counterparty files tax
INTERNAL_PTY	VARCHAR2	(1)		Flag to indicate if the party is an internal party (Y), or not (N)
PARTY_CATEGORY	VARCHAR2	(2)		Not currently used
BROKER	VARCHAR2	(1)		Not currently used
CLIENT_YN	VARCHAR2	(1)		Flag to indicate if the counterparty is a client (Y), or not (N)
CROSS_REF_TO_OTHER_PARTY	VARCHAR2	(7)		Party cross reference
CLIENT_GROUPING	VARCHAR2	(7)		Client group code
STATE_CODE	VARCHAR2	(3)		Counterparty state code
TITLE_DESCRIPTION	VARCHAR2	(50)		Counterparty contact title
PARTY_GROUP	VARCHAR2	(7)		Deal confirmation group to which the party belongs
SETTLEMENT_DEFAULT_CATEGORY	VARCHAR2	(7)		Counterparty settlement category
TAX_CATEGORY	VARCHAR2	(7)		Tax category
BROKERAGE_CATEGORY	VARCHAR2	(7)		Counterparty brokerage category
TAX_EXEMPTION_CODE	VARCHAR2	(15)		Counterparty tax exemption code
CLIENT_ADVICE	VARCHAR2	(1)		Flag to indicate if confirmation advice letter is required for the party's confirmation actions (Y), or not (N)
CLIENT_AGENT1	VARCHAR2	(20)		Party that provides legal service for the counterparty
CLIENT_AGENT2	VARCHAR2	(20)		Party that provides accounting service for the counterparty
CLIENT_AGENT3	VARCHAR2	(20)		Party that provides an 'Other' service for the counterparty
ACCOUNT_MANAGER	VARCHAR2	(10)		Cparty account manager
AUDIT_INDICATOR	VARCHAR2	(1)		Audit Indicator
ADVISOR_YN	VARCHAR2	(1)		Flag to indicate if the counterparty acts as a legal or accounting advisor (Y), or not (N)
VALUER_YN	VARCHAR2	(1)		Flag to determine if the party is a valuer (Y), or not (N)
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
EMAIL_ADDRESS	VARCHAR2	(40)		Email address of a party
DEPOSIT_REF	VARCHAR2	(10)		Reference to a deposit made
COMMENTS	VARCHAR2	(255)		Comments for the counterparty
ACCOUNT_STATUS	VARCHAR2	(14)		Not currently used
CONFO_GROUP_CODE	VARCHAR2	(20)		Confirmation group code
CONFO_ACTION_CODE	VARCHAR2	(20)		Not currently used
PI_CONSTANT	VARCHAR2	(1)		Not currently used
PAGER_NUMBER	NUMBER			Pager number of a party
BRANCH_SUBSIDIARY_CODE	VARCHAR2	(7)		Not currently used
BRANCH_SUBSIDIARY_YN	VARCHAR2	(1)		Not currently used
DEFAULT_ADDRESS_DETAILS	VARCHAR2	(1)		Flag to indicate if a set of address details should be set as default (Y), or not (N)
SWIFT_ID	VARCHAR2	(11)		Bank transit identifier
FX_MATCH_ID	VARCHAR2	(11)		Identifier used in Citibank's foreign exchange deal confirmation and matching services
FX_CPARTY	VARCHAR2	(1)		Flag to indicate if that party is involved in foreign exchange (Y), or not (N)
MM_CPARTY	VARCHAR2	(1)		Flag to indicate if a counterparty is involved in the money market (Y), or not (N)
EM_CPARTY	VARCHAR2	(1)		To specify if the cparty is the Equity Market cparty
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
SUSPENSE_CCID	NUMBER	(15)		Suspense account identifier
CONVERSION_TYPE	VARCHAR2	(30)		Exchange rate type
SET_OF_BOOKS_ID	NUMBER	(15)		Set of books identifier
CHART_OF_ACCOUNTS_ID	NUMBER	(15)		Key flexfield structure defining column
SET_OF_BOOKS_CURRENCY	VARCHAR2	(15)		Set of books currency

Query Text

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


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

Dependencies

[top of page]

APPS.XTR_PARTIES_V references the following:

APPS: GL_SETS_OF_BOOKS; XTR_COMPANY_AUTHORITIES; XTR_PARTY_INFO; XTR_PRO_PARAM; XTR_USER_ACCESS - show dependent code

APPS.XTR_PARTIES_V is referenced by following:

APPS: CE_FC_BANK_BAL_DISC_V; CE_FORECAST_UTILS - show dependent code; CE_LE_BG_OU_VS_V; CE_SECURITY_PROFILES_V; XTR_ACCOUNT_BAL_MAINT_P - show dependent code; XTR_ACCOUNT_MANAGERS_V; XTR_AD_MIRROR_DDA_LIMIT_ROW_T; XTR_AI_MIRROR_DDA_LIMIT_ROW_T; XTR_AI_MIRROR_DDA_TMP_T; XTR_AP_OPEN_APLD_TRX_V; XTR_AP_OPEN_TRX_V; XTR_AP_ORIG_TRX_V; XTR_AR_OPEN_APLD_TRX_V; XTR_AR_OPEN_TRX_V; XTR_AR_ORIG_TRX_V; XTR_AU_MIRROR_DDA_LIMIT_ROW_T; XTR_BIS_CASHFLOWS_V; XTR_BIS_LIMIT_OVERVIEW_V; XTR_BIS_MIRROR_DDA_LIMIT_ROW_V; XTR_CASH_FCST - show dependent code; XTR_COF_P - show dependent code; XTR_CONFO_PROCESS_P - show dependent code; XTR_DDA_EXPOSURES_V; XTR_DEALS_INTERFACE_V; XTR_DNM_PKG - show dependent code; XTR_EFT_SCRIPT_P - show dependent code; XTR_EXP_SUMM_P - show dependent code; XTR_EXP_TRANSFERS_PKG - show dependent code; XTR_FPS1_P - show dependent code; XTR_FPS2_P - show dependent code; XTR_FX_EXPOSURES_VIEW_V; XTR_FX_TRANSFERS_PKG - show dependent code; XTR_HEDGE_PROCESS_P - show dependent code; XTR_IAC_TRANSFERS_PKG - show dependent code; XTR_IG_TRANSFERS_PKG - show dependent code; XTR_IMPORT_DEAL_DATA - show dependent code; XTR_JOURNAL_PROCESS_P - show dependent code; XTR_LIMITS_P - show dependent code; XTR_LIMIT_OVERVIEW_V; XTR_MAINTAIN_DDA_P - show dependent code; XTR_MISC_P - show dependent code; XTR_NI_TRANSFERS_PKG - show dependent code; XTR_ORACLE_FIN_INTERFACES_P - show dependent code; XTR_REPLICATE_BANK_ACCOUNTS_P - show dependent code; XTR_REPLICATE_BANK_BALANCES - show dependent code; XTR_STREAMLINE_P - show dependent code; XTR_SWIFT_EFT_V; XTR_UPDATE_SETTLEMENT_ACCOUNTS - show dependent code; XTR_WRAPPER_API_P - show dependent code; XTR_XTRDDHTY_XMLP_PKG - show dependent code; XTR_XTROHINS_XMLP_PKG - show dependent code