155: SELECT
156: DISTINCT
157: ORGANIZATION_ID
158: FROM
159: JAI_RGM_ORG_REGNS_V
160: WHERE REGIME_CODE = 'SERVICE'
161: AND REGISTRATION_TYPE = 'OTHERS'
162: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
163: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'
206: SELECT
207: DISTINCT
208: ORGANIZATION_ID
209: FROM
210: JAI_RGM_ORG_REGNS_V
211: WHERE REGIME_CODE = 'SERVICE'
212: AND REGISTRATION_TYPE = 'OTHERS'
213: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
214: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'
443: SELECT
444: DISTINCT
445: ORGANIZATION_ID
446: FROM
447: JAI_RGM_ORG_REGNS_V
448: WHERE REGIME_CODE = 'SERVICE'
449: AND REGISTRATION_TYPE = 'OTHERS'
450: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
451: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'
675: SELECT
676: DISTINCT
677: ORGANIZATION_ID
678: FROM
679: JAI_RGM_ORG_REGNS_V
680: WHERE REGIME_CODE = 'SERVICE'
681: AND REGISTRATION_TYPE = 'OTHERS'
682: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
683: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'
726: SELECT
727: DISTINCT
728: ORGANIZATION_ID
729: FROM
730: JAI_RGM_ORG_REGNS_V
731: WHERE REGIME_CODE = 'SERVICE'
732: AND REGISTRATION_TYPE = 'OTHERS'
733: AND ATTRIBUTE_TYPE_CODE = 'PRIMARY'
734: AND ATTRIBUTE_CODE = 'SERVICE_TAX_REGISTRATION_NO'