VIEW: IGI.IGI_CIS_MTH_RET_HDR_H_ALL#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, REQUEST_ID REQUEST_ID, ORG_ID ORG_ID, REQUEST_STATUS_CODE REQUEST_STATUS_CODE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM, ACCOUNTS_OFFICE_REFERENCE ACCOUNTS_OFFICE_REFERENCE, PERIOD_NAME PERIOD_NAME, PERIOD_ENDING_DATE PERIOD_ENDING_DATE, NIL_RETURN_FLAG NIL_RETURN_FLAG, EMPLOYMENT_STATUS_FLAG EMPLOYMENT_STATUS_FLAG, SUBCONT_VERIFY_FLAG SUBCONT_VERIFY_FLAG, INFORMATION_CORRECT_FLAG INFORMATION_CORRECT_FLAG, INACTIVITY_INDICATOR INACTIVITY_INDICATOR, CIS_SENDER_ID CIS_SENDER_ID, TAX_OFFICE_NUMBER TAX_OFFICE_NUMBER, PAYE_REFERENCE PAYE_REFERENCE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY from "IGI"."IGI_CIS_MTH_RET_HDR_H_ALL"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, REQUEST_ID REQUEST_ID
, ORG_ID ORG_ID
, REQUEST_STATUS_CODE REQUEST_STATUS_CODE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, UNIQUE_TAX_REFERENCE_NUM UNIQUE_TAX_REFERENCE_NUM
, ACCOUNTS_OFFICE_REFERENCE ACCOUNTS_OFFICE_REFERENCE
, PERIOD_NAME PERIOD_NAME
, PERIOD_ENDING_DATE PERIOD_ENDING_DATE
, NIL_RETURN_FLAG NIL_RETURN_FLAG
, EMPLOYMENT_STATUS_FLAG EMPLOYMENT_STATUS_FLAG
, SUBCONT_VERIFY_FLAG SUBCONT_VERIFY_FLAG
, INFORMATION_CORRECT_FLAG INFORMATION_CORRECT_FLAG
, INACTIVITY_INDICATOR INACTIVITY_INDICATOR
, CIS_SENDER_ID CIS_SENDER_ID
, TAX_OFFICE_NUMBER TAX_OFFICE_NUMBER
, PAYE_REFERENCE PAYE_REFERENCE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
FROM "IGI"."IGI_CIS_MTH_RET_HDR_H_ALL"