VIEW: JA.JAI_RGM_CERTIFICATES#

Source

View Text - Preformatted

select CERTIFICATE_ID CERTIFICATE_ID, CERTIFICATE_NUM CERTIFICATE_NUM, CERTIFICATE_DATE CERTIFICATE_DATE, PARTY_TYPE PARTY_TYPE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, REGIME_ID REGIME_ID, TAX_AUTHORITY_ID TAX_AUTHORITY_ID, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID, FROM_DATE FROM_DATE, TO_DATE TO_DATE, PRINT_FLAG PRINT_FLAG, ORGANIZATION_ID ORGANIZATION_ID, ISSUE_DATE ISSUE_DATE, FIN_YEAR FIN_YEAR, ORG_TAN_NO ORG_TAN_NO, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "JA"."JAI_RGM_CERTIFICATES"

View Text - HTML Formatted

SELECT CERTIFICATE_ID CERTIFICATE_ID
, CERTIFICATE_NUM CERTIFICATE_NUM
, CERTIFICATE_DATE CERTIFICATE_DATE
, PARTY_TYPE PARTY_TYPE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, REGIME_ID REGIME_ID
, TAX_AUTHORITY_ID TAX_AUTHORITY_ID
, TAX_AUTHORITY_SITE_ID TAX_AUTHORITY_SITE_ID
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, PRINT_FLAG PRINT_FLAG
, ORGANIZATION_ID ORGANIZATION_ID
, ISSUE_DATE ISSUE_DATE
, FIN_YEAR FIN_YEAR
, ORG_TAN_NO ORG_TAN_NO
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "JA"."JAI_RGM_CERTIFICATES"