1. Tables and Views for Procurement
  2. POR_THIRD_PTY_REG_V

POR_THIRD_PTY_REG_V

Details

  • Schema: FUSION

  • Object owner: POR

  • Object type: VIEW

Columns

Name

THIRD_PTY_REG_ID

REGISTRATION_NUMBER

PTY_SITE_NAME

REG_TYPE

TAX_REGIME

TAX

JURISDICATION

Query

SQL_Statement

SELECT distinct zxregst.registration_id third_pty_reg_id,

zxregst.registration_number registration_number,

null pty_site_name,

zxregst.registration_type_code reg_type,

zxregst. tax_regime_code tax_regime,

zxregst.tax tax,

zxregst.tax_jurisdiction_code jurisdication

FROM ZX_REGISTRATIONS zxregst, ZX_PARTY_TAX_PROFILE zxptp, HZ_PARTIES hzParties

WHERE zxregst.party_tax_profile_id = zxptp.party_tax_profile_id

AND hzParties.party_id = zxptp.party_id

AND zxptp.party_type_code = 'THIRD_PARTY'

AND zxregst.registration_number IS NOT NULL

AND zxregst.effective_from <= TRUNC(SYSDATE)

AND (zxregst.effective_to IS NULL OR zxregst.effective_to >= TRUNC(SYSDATE))

UNION

SELECT distinct zxregst.registration_id third_pty_reg_id,

zxregst.registration_number registration_number,

hzPartySites.party_site_name pty_site_name,

zxregst.registration_type_code reg_type,

zxregst. tax_regime_code tax_regime,

zxregst.tax tax,

zxregst.tax_jurisdiction_code jurisdication

FROM ZX_REGISTRATIONS zxregst, ZX_PARTY_TAX_PROFILE zxptp, HZ_PARTY_SITES hzPartySites, HZ_PARTIES hzParties

WHERE zxregst.party_tax_profile_id = zxptp.party_tax_profile_id

AND hzPartySites.party_site_id = zxptp.party_id

AND zxptp.party_type_code = 'THIRD_PARTY_SITE'

AND zxregst.registration_number IS NOT NULL

AND hzPartySites.party_id = hzParties.party_id

AND zxregst.effective_from <= TRUNC(SYSDATE)

AND (zxregst.effective_to IS NULL OR zxregst.effective_to >= TRUNC(SYSDATE))