View: JAI_RGM_ORG_REGNS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_RGM_ORG_REGNS_V

View Text

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

Columns