VIEW: APPS.JAI_RGM_PARTY_REGNS_V

Source

View Text - Preformatted

SELECT decode( prrg.registration_id , NULL , rgrg.rowid , prrg.rowid ) row_id , rgrg.regime_id , rgrg.registration_id , prrg.regime_org_id , decode( prrg.registration_id , NULL , rgrg.attribute_value , prrg.attribute_value ) attribute_value , rgrg.registration_type , rgrg.attribute_sequence , rgrg.attribute_type_code , rgrg.attribute_code , rgrg.parent_registration_id , rgrg.rate , decode( prrg.registration_id , NULL , rgrg.creation_date , prrg.creation_date ) creation_date , decode( prrg.registration_id , NULL , rgrg.created_by , prrg.created_by ) created_by , decode( prrg.registration_id , NULL , rgrg.last_update_date , prrg.last_update_date ) last_update_date , decode( prrg.registration_id , NULL , rgrg.last_updated_by , prrg.last_updated_by ) last_updated_by FROM jai_rgm_party_regns prrg , JAI_RGM_REGISTRATIONS rgrg WHERE rgrg.registration_id = prrg.registration_id (+)

View Text - HTML Formatted

SELECT DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.ROWID
, PRRG.ROWID ) ROW_ID
, RGRG.REGIME_ID
, RGRG.REGISTRATION_ID
, PRRG.REGIME_ORG_ID
, DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.ATTRIBUTE_VALUE
, PRRG.ATTRIBUTE_VALUE ) ATTRIBUTE_VALUE
, RGRG.REGISTRATION_TYPE
, RGRG.ATTRIBUTE_SEQUENCE
, RGRG.ATTRIBUTE_TYPE_CODE
, RGRG.ATTRIBUTE_CODE
, RGRG.PARENT_REGISTRATION_ID
, RGRG.RATE
, DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.CREATION_DATE
, PRRG.CREATION_DATE ) CREATION_DATE
, DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.CREATED_BY
, PRRG.CREATED_BY ) CREATED_BY
, DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.LAST_UPDATE_DATE
, PRRG.LAST_UPDATE_DATE ) LAST_UPDATE_DATE
, DECODE( PRRG.REGISTRATION_ID
, NULL
, RGRG.LAST_UPDATED_BY
, PRRG.LAST_UPDATED_BY ) LAST_UPDATED_BY
FROM JAI_RGM_PARTY_REGNS PRRG
, JAI_RGM_REGISTRATIONS RGRG
WHERE RGRG.REGISTRATION_ID = PRRG.REGISTRATION_ID (+)