Product: | XTR - Treasury |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XTR_PARTY_INFO_V |
SELECT PI.PARTY_CODE
, PI.PARTY_TYPE
, PI.SHORT_NAME
, PI.FULL_NAME
, PI.CREATED_BY
, PI.CREATED_ON
, PI.RISK_PARTY
, PI.DEFAULT_COMPANY
, PI.UPDATED_BY
, PI.UPDATED_ON
, PI.CONTACT_NAME
, PI.PHONE_NUMBER
, PI.FAX_NUMBER
, PI.ADDRESS_1
, PI.ADDRESS_2
, PI.ADDRESS_3
, PI.ADDRESS_4
, PI.ADDRESS_5
, PI.ADDRESS_6
, PI.COUNTRY_CODE
, PI.AUTHORISED
, PI.TAX_NUMBER
, PI.INTERNAL_PTY
, PI.PARTY_CATEGORY
, PI.BROKER
, PI.CLIENT_YN
, PI.CROSS_REF_TO_OTHER_PARTY
, PI.CLIENT_GROUPING
, PI.STATE_CODE
, PI.TITLE_DESCRIPTION
, PI.PARTY_GROUP
, PI.SETTLEMENT_DEFAULT_CATEGORY
, PI.TAX_CATEGORY
, PI.BROKERAGE_CATEGORY
, PI.TAX_EXEMPTION_CODE
, PI.CLIENT_ADVICE
, PI.CLIENT_AGENT1
, PI.CLIENT_AGENT2
, PI.CLIENT_AGENT3
, PI.ACCOUNT_MANAGER
, DC.DEALER_USER_NAME
, PI.AUDIT_INDICATOR
, PI.ADVISOR_YN
, PI.VALUER_YN
, PI.P_ADDRESS_1
, PI.P_ADDRESS_2
, PI.P_ADDRESS_3
, PI.P_ADDRESS_4
, PI.EMAIL_ADDRESS
, PI.DEPOSIT_REF
, PI.COMMENTS
, PI.ACCOUNT_STATUS
, PI.CONFO_GROUP_CODE
, PI.CONFO_ACTION_CODE
, PI.PI_CONSTANT
, PI.PAGER_NUMBER
, PI.BRANCH_SUBSIDIARY_CODE
, PI.BRANCH_SUBSIDIARY_YN
, PI.DEFAULT_ADDRESS_DETAILS
, PI.SWIFT_ID
, PI.FX_MATCH_ID
, PI.FX_CPARTY
, PI.MM_CPARTY
, PI.EM_CPARTY
, PI.LEGAL_ENTITY_ID
, PI.SUSPENSE_CCID
, PI.CONVERSION_TYPE
, PI.SET_OF_BOOKS_ID
, PI.CHART_OF_ACCOUNTS_ID
FROM XTR_PARTY_INFO PI
, XTR_DEALER_CODES DC
WHERE PI.ACCOUNT_MANAGER = DC.DEALER_CODE (+)