VIEW: APPS.JAI_AP_TDS_ORG_TAN_V

Source

View Text - Preformatted

SELECT jrp.organization_id ORGANIZATION_ID, NVL(jpr.attribute_value, jrr.attribute_value) ORG_TAN_NUM FROM jai_rgm_parties jrp, jai_rgm_registrations jrr, jai_rgm_party_regns jpr, jai_rgm_definitions jrg WHERE jrg.regime_id = jrp.regime_id AND jrp.regime_org_id = jpr.regime_org_id(+) AND jrg.regime_code = 'TDS' AND jrr.registration_type = 'OTHERS' AND jrr.attribute_type_code = 'PRIMARY' AND jrr.attribute_code = 'TAN NO' AND ( jpr.registration_id is null or jpr.registration_id = jrr.registration_id )

View Text - HTML Formatted

SELECT JRP.ORGANIZATION_ID ORGANIZATION_ID
, NVL(JPR.ATTRIBUTE_VALUE
, JRR.ATTRIBUTE_VALUE) ORG_TAN_NUM
FROM JAI_RGM_PARTIES JRP
, JAI_RGM_REGISTRATIONS JRR
, JAI_RGM_PARTY_REGNS JPR
, JAI_RGM_DEFINITIONS JRG
WHERE JRG.REGIME_ID = JRP.REGIME_ID
AND JRP.REGIME_ORG_ID = JPR.REGIME_ORG_ID(+)
AND JRG.REGIME_CODE = 'TDS'
AND JRR.REGISTRATION_TYPE = 'OTHERS'
AND JRR.ATTRIBUTE_TYPE_CODE = 'PRIMARY'
AND JRR.ATTRIBUTE_CODE = 'TAN NO'
AND ( JPR.REGISTRATION_ID IS NULL OR JPR.REGISTRATION_ID = JRR.REGISTRATION_ID )