VIEW: APPS.XTR_PARTIES_V

Source

View Text - Preformatted

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.fx_cparty, xpi.mm_cparty, xpi.em_cparty, xpi.legal_entity_id, xpi.suspense_ccid, xpi.conversion_type, xpi.set_of_books_id, xpi.chart_of_accounts_id, sob.currency_code FROM XTR_PARTY_INFO xpi, XTR_PRO_PARAM xpp, GL_SETS_OF_BOOKS SOB WHERE 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 WHERE xca.dealer_code = xtr_user_access.dealer_code AND xca.company_authorised_for_input = 'Y' ) ) OR xpi.party_type <> 'C' ) AND sob.set_of_books_id (+) = xpi.set_of_books_id

View Text - HTML Formatted

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.FX_CPARTY
, XPI.MM_CPARTY
, XPI.EM_CPARTY
, XPI.LEGAL_ENTITY_ID
, XPI.SUSPENSE_CCID
, XPI.CONVERSION_TYPE
, XPI.SET_OF_BOOKS_ID
, XPI.CHART_OF_ACCOUNTS_ID
, SOB.CURRENCY_CODE
FROM XTR_PARTY_INFO XPI
, XTR_PRO_PARAM XPP
, GL_SETS_OF_BOOKS SOB
WHERE 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
WHERE XCA.DEALER_CODE = XTR_USER_ACCESS.DEALER_CODE
AND XCA.COMPANY_AUTHORISED_FOR_INPUT = 'Y' ) ) OR XPI.PARTY_TYPE <> 'C' )
AND SOB.SET_OF_BOOKS_ID (+) = XPI.SET_OF_BOOKS_ID