VIEW: APPS.XTR_PARTY_INFO_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)