VIEW: APPS.JAI_RGM_ORG_REGNS_V

Source

View Text - Preformatted

SELECT rgms.regime_id regime_id , rgms.regime_code regime_code , rgms.description description , rgms.effective_date_from effective_date_from , rgms.effective_date_to effective_date_to , rgpt.regime_org_id regime_org_id , rgpt.organization_type organization_type , rgpt.organization_id organization_id , rgpt.location_id location_id , rgpt.authority_id authority_id , rgpt.authority_site_id authority_site_id , rgrg.registration_id registration_id , rgrg.registration_type registration_type , rgrg.attribute_sequence attribute_sequence , rgrg.attribute_type_code attribute_type_code , rgrg.attribute_code attribute_code , rgrg.attribute_value attribute_value , rgrg.parent_registration_id parent_registration_id , rgrg.rate rate , rgpt.creation_date creation_date , rgpt.created_by created_by , rgpt.last_update_date last_update_date , rgpt.last_updated_by last_updated_by FROM JAI_RGM_DEFINITIONS rgms, jai_rgm_parties rgpt, JAI_RGM_REGISTRATIONS rgrg WHERE rgms.regime_id = rgpt.regime_id AND rgms.regime_id = rgrg.regime_id AND NOT EXISTS ( SELECT 1 FROM jai_rgm_party_regns rprg WHERE rprg.regime_org_id = rgpt.regime_org_id AND rprg.registration_id = rgrg.registration_id ) UNION ALL SELECT rgms.regime_id regime_id , rgms.regime_code regime_code , rgms.description description , rgms.effective_date_from effective_date_from , rgms.effective_date_to effective_date_to , rgpt.regime_org_id regime_org_id , rgpt.organization_type organization_type , rgpt.organization_id organization_id , rgpt.location_id location_id , rgpt.authority_id authority_id , rgpt.authority_site_id authority_site_id , rgrg.registration_id registration_id , rgrg.registration_type registration_type , rgrg.attribute_sequence attribute_sequence , rgrg.attribute_type_code attribute_type_code , rgrg.attribute_code attribute_code , rprg.attribute_value attribute_value , rgrg.parent_registration_id parent_registration_id , rgrg.rate rate , rprg.creation_date creation_date , rprg.created_by created_by , rprg.last_update_date last_update_date , rprg.last_updated_by last_updated_by FROM JAI_RGM_DEFINITIONS rgms, jai_rgm_parties rgpt, JAI_RGM_REGISTRATIONS rgrg, jai_rgm_party_regns rprg WHERE rgms.regime_id = rgpt.regime_id AND rgms.regime_id = rgrg.regime_id AND rgrg.registration_id = rprg.registration_id AND rprg.regime_org_id = rgpt.regime_org_id

View Text - HTML Formatted

SELECT RGMS.REGIME_ID REGIME_ID
, RGMS.REGIME_CODE REGIME_CODE
, RGMS.DESCRIPTION DESCRIPTION
, RGMS.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, RGMS.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, RGPT.REGIME_ORG_ID REGIME_ORG_ID
, RGPT.ORGANIZATION_TYPE ORGANIZATION_TYPE
, RGPT.ORGANIZATION_ID ORGANIZATION_ID
, RGPT.LOCATION_ID LOCATION_ID
, RGPT.AUTHORITY_ID AUTHORITY_ID
, RGPT.AUTHORITY_SITE_ID AUTHORITY_SITE_ID
, RGRG.REGISTRATION_ID REGISTRATION_ID
, RGRG.REGISTRATION_TYPE REGISTRATION_TYPE
, RGRG.ATTRIBUTE_SEQUENCE ATTRIBUTE_SEQUENCE
, RGRG.ATTRIBUTE_TYPE_CODE ATTRIBUTE_TYPE_CODE
, RGRG.ATTRIBUTE_CODE ATTRIBUTE_CODE
, RGRG.ATTRIBUTE_VALUE ATTRIBUTE_VALUE
, RGRG.PARENT_REGISTRATION_ID PARENT_REGISTRATION_ID
, RGRG.RATE RATE
, RGPT.CREATION_DATE CREATION_DATE
, RGPT.CREATED_BY CREATED_BY
, RGPT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RGPT.LAST_UPDATED_BY LAST_UPDATED_BY
FROM JAI_RGM_DEFINITIONS RGMS
, JAI_RGM_PARTIES RGPT
, JAI_RGM_REGISTRATIONS RGRG
WHERE RGMS.REGIME_ID = RGPT.REGIME_ID
AND RGMS.REGIME_ID = RGRG.REGIME_ID
AND NOT EXISTS ( SELECT 1
FROM JAI_RGM_PARTY_REGNS RPRG
WHERE RPRG.REGIME_ORG_ID = RGPT.REGIME_ORG_ID
AND RPRG.REGISTRATION_ID = RGRG.REGISTRATION_ID ) UNION ALL SELECT RGMS.REGIME_ID REGIME_ID
, RGMS.REGIME_CODE REGIME_CODE
, RGMS.DESCRIPTION DESCRIPTION
, RGMS.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, RGMS.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, RGPT.REGIME_ORG_ID REGIME_ORG_ID
, RGPT.ORGANIZATION_TYPE ORGANIZATION_TYPE
, RGPT.ORGANIZATION_ID ORGANIZATION_ID
, RGPT.LOCATION_ID LOCATION_ID
, RGPT.AUTHORITY_ID AUTHORITY_ID
, RGPT.AUTHORITY_SITE_ID AUTHORITY_SITE_ID
, RGRG.REGISTRATION_ID REGISTRATION_ID
, RGRG.REGISTRATION_TYPE REGISTRATION_TYPE
, RGRG.ATTRIBUTE_SEQUENCE ATTRIBUTE_SEQUENCE
, RGRG.ATTRIBUTE_TYPE_CODE ATTRIBUTE_TYPE_CODE
, RGRG.ATTRIBUTE_CODE ATTRIBUTE_CODE
, RPRG.ATTRIBUTE_VALUE ATTRIBUTE_VALUE
, RGRG.PARENT_REGISTRATION_ID PARENT_REGISTRATION_ID
, RGRG.RATE RATE
, RPRG.CREATION_DATE CREATION_DATE
, RPRG.CREATED_BY CREATED_BY
, RPRG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RPRG.LAST_UPDATED_BY LAST_UPDATED_BY
FROM JAI_RGM_DEFINITIONS RGMS
, JAI_RGM_PARTIES RGPT
, JAI_RGM_REGISTRATIONS RGRG
, JAI_RGM_PARTY_REGNS RPRG
WHERE RGMS.REGIME_ID = RGPT.REGIME_ID
AND RGMS.REGIME_ID = RGRG.REGIME_ID
AND RGRG.REGISTRATION_ID = RPRG.REGISTRATION_ID
AND RPRG.REGIME_ORG_ID = RGPT.REGIME_ORG_ID