View: JAI_AP_TDS_ORG_TAN_V

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

View Text

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 )

Columns