Product: | XTR - Treasury |
---|---|
Description: | General information of Treasury parties, where user access to company information is enforced |
Implementation/DBA Data: | APPS.XTR_PARTIES_V |
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