VIEW: APPS.JAI_AP_TDS_ORG_TAN_V

Source

View Text - Preformatted

SELECT organization_id, attribute_value org_tan_num from jai_rgm_org_regns_v WHERE regime_code = 'TDS' and registration_type = 'OTHERS' and attribute_type_code = 'PRIMARY' and attribute_code = 'TAN NO'

View Text - HTML Formatted

SELECT ORGANIZATION_ID
, ATTRIBUTE_VALUE ORG_TAN_NUM
FROM JAI_RGM_ORG_REGNS_V
WHERE REGIME_CODE = 'TDS'
AND REGISTRATION_TYPE = 'OTHERS'
AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
AND ATTRIBUTE_CODE = 'TAN NO'