VIEW: APPS.XTR_A_PARTY_INFO_V

Source

View Text - Preformatted

SELECT PARTY_CODE, PARTY_TYPE, SHORT_NAME, FULL_NAME, CREATED_BY, CREATED_ON, RISK_PARTY, DEFAULT_COMPANY, UPDATED_BY, UPDATED_ON, 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, 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, AUDIT_INDICATOR, AUDIT_DATE_STORED, FX_CPARTY, MM_CPARTY, LEGAL_ENTITY_ID, SUSPENSE_CCID, CONVERSION_TYPE, SET_OF_BOOKS_ID, CHART_OF_ACCOUNTS_ID from XTR_A_PARTY_INFO

View Text - HTML Formatted

SELECT PARTY_CODE
, PARTY_TYPE
, SHORT_NAME
, FULL_NAME
, CREATED_BY
, CREATED_ON
, RISK_PARTY
, DEFAULT_COMPANY
, UPDATED_BY
, UPDATED_ON
, 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
, 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
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, FX_CPARTY
, MM_CPARTY
, LEGAL_ENTITY_ID
, SUSPENSE_CCID
, CONVERSION_TYPE
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
FROM XTR_A_PARTY_INFO