VIEW: XTR.XTR_A_PARTY_INFO#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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