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.

[Home] [Help]

View: XTR_PARTIES_HR_V

Product:	XTR - Treasury
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT XPI.PARTY_CODE
, XPI.PARTY_TYPE
, XPI.SHORT_NAME
, XPI.FULL_NAME
, XPI.CREATED_BY
, XPI.CREATED_ON
, XPI.RISK_PARTY
, XPI.DEFAULT_COMPANY
, XPI.UPDATED_BY
, XPI.UPDATED_ON
, SUBSTR(XPP.PARAM_VALUE
, 1
, 15)
, XPI.CONTACT_NAME
, XPI.PHONE_NUMBER
, XPI.FAX_NUMBER
, XPI.ADDRESS_1
, XPI.ADDRESS_2
, XPI.ADDRESS_3
, XPI.ADDRESS_4
, XPI.ADDRESS_5
, XPI.ADDRESS_6
, XPI.COUNTRY_CODE
, XPI.AUTHORISED
, XPI.TAX_NUMBER
, XPI.INTERNAL_PTY
, XPI.PARTY_CATEGORY
, XPI.BROKER
, XPI.CLIENT_YN
, XPI.CROSS_REF_TO_OTHER_PARTY
, XPI.CLIENT_GROUPING
, XPI.STATE_CODE
, XPI.TITLE_DESCRIPTION
, XPI.PARTY_GROUP
, XPI.SETTLEMENT_DEFAULT_CATEGORY
, XPI.TAX_CATEGORY
, XPI.BROKERAGE_CATEGORY
, XPI.TAX_EXEMPTION_CODE
, XPI.CLIENT_ADVICE
, XPI.CLIENT_AGENT1
, XPI.CLIENT_AGENT2
, XPI.CLIENT_AGENT3
, XPI.ACCOUNT_MANAGER
, XPI.AUDIT_INDICATOR
, XPI.ADVISOR_YN
, XPI.VALUER_YN
, XPI.P_ADDRESS_1
, XPI.P_ADDRESS_2
, XPI.P_ADDRESS_3
, XPI.P_ADDRESS_4
, XPI.EMAIL_ADDRESS
, XPI.DEPOSIT_REF
, XPI.COMMENTS
, XPI.ACCOUNT_STATUS
, XPI.CONFO_GROUP_CODE
, XPI.CONFO_ACTION_CODE
, XPI.PI_CONSTANT
, XPI.PAGER_NUMBER
, XPI.BRANCH_SUBSIDIARY_CODE
, XPI.BRANCH_SUBSIDIARY_YN
, XPI.DEFAULT_ADDRESS_DETAILS
, XPI.SWIFT_ID
, XPI.FX_MATCH_ID
, XPI.LEGAL_ENTITY_ID
, HLE.NAME
, XPI.SET_OF_BOOKS_ID
, GSB.NAME
, GSB.CURRENCY_CODE
, XPI.CHART_OF_ACCOUNTS_ID
, XPI.FX_CPARTY
, XPI.MM_CPARTY
, XPI.SUSPENSE_CCID
, XPI.CONVERSION_TYPE
FROM XTR_PARTY_INFO XPI
, HR_LEGAL_ENTITIES HLE
, GL_SETS_OF_BOOKS GSB
, XTR_PRO_PARAM XPP WHERE XPI.LEGAL_ENTITY_ID = HLE.ORGANIZATION_ID (+) AND HLE.SET_OF_BOOKS_ID = GSB.SET_OF_BOOKS_ID (+) AND XPP.PARAM_NAME = 'SYSTEM_FUNCTIONAL_CCY' AND XPI.AUTHORISED = 'Y' AND ((XPI.PARTY_TYPE = 'C' AND XPI.PARTY_CODE IN (SELECT XCA.PARTY_CODE FROM XTR_COMPANY_AUTHORITIES XCA
, XTR_DEALER_CODES XDC WHERE XPI.PARTY_CODE = XCA.PARTY_CODE AND XCA.DEALER_CODE = XDC.DEALER_CODE AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' AND XDC.USER_ID = FND_GLOBAL.USER_ID)) OR XPI.PARTY_TYPE <> 'C')

Columns

Name
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
LEGAL_ENTITY_ID
LEGAL_ENTITY_NAME
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
BASE_CURRENCY
CHART_OF_ACCOUNTS_ID
FX_CPARTY
MM_CPARTY
SUSPENSE_CCID
CONVERSION_TYPE