VIEW: FV.FV_FACTS_SUBMISSION#

Source

View Text - Preformatted

select TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID, RUN_MODE RUN_MODE, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PREPARER_ID PREPARER_ID, CERTIFIED_ID CERTIFIED_ID, REP_FYR REP_FYR, REP_QTR REP_QTR, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, PHONE_NO PHONE_NO, PHONE_EXT PHONE_EXT, AGENCY_NAME_1 AGENCY_NAME_1, AGENCY_NAME_2 AGENCY_NAME_2, ADDRESS_1 ADDRESS_1, ADDRESS_2 ADDRESS_2, CITY CITY, STATE STATE, ZIP ZIP, SUPERVISOR_NAME SUPERVISOR_NAME, SUPERVISOR_PHONE SUPERVISOR_PHONE, SUPERVISOR_EXT SUPERVISOR_EXT, EMAIL_ADDRESS EMAIL_ADDRESS, FAX_NUM FAX_NUM, MOTHERS_M_NAME MOTHERS_M_NAME, SUBMITTED_ID SUBMITTED_ID, SUBMITTED_BY SUBMITTED_BY, SUBMITTED_STATUS SUBMITTED_STATUS, FACTS2_STATUS FACTS2_STATUS, SUBMIT_FLAG SUBMIT_FLAG, PURGE_FLAG PURGE_FLAG, BULK_FLAG BULK_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BULK_FILE_SUB_ID BULK_FILE_SUB_ID, CURRENCY_CODE CURRENCY_CODE, FOOT_NOTE_FLAG FOOT_NOTE_FLAG, CONTACT_ID CONTACT_ID, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, REP_PERIOD_NUM REP_PERIOD_NUM from "FV"."FV_FACTS_SUBMISSION"

View Text - HTML Formatted

SELECT TREASURY_SYMBOL_ID TREASURY_SYMBOL_ID
, RUN_MODE RUN_MODE
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PREPARER_ID PREPARER_ID
, CERTIFIED_ID CERTIFIED_ID
, REP_FYR REP_FYR
, REP_QTR REP_QTR
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, PHONE_NO PHONE_NO
, PHONE_EXT PHONE_EXT
, AGENCY_NAME_1 AGENCY_NAME_1
, AGENCY_NAME_2 AGENCY_NAME_2
, ADDRESS_1 ADDRESS_1
, ADDRESS_2 ADDRESS_2
, CITY CITY
, STATE STATE
, ZIP ZIP
, SUPERVISOR_NAME SUPERVISOR_NAME
, SUPERVISOR_PHONE SUPERVISOR_PHONE
, SUPERVISOR_EXT SUPERVISOR_EXT
, EMAIL_ADDRESS EMAIL_ADDRESS
, FAX_NUM FAX_NUM
, MOTHERS_M_NAME MOTHERS_M_NAME
, SUBMITTED_ID SUBMITTED_ID
, SUBMITTED_BY SUBMITTED_BY
, SUBMITTED_STATUS SUBMITTED_STATUS
, FACTS2_STATUS FACTS2_STATUS
, SUBMIT_FLAG SUBMIT_FLAG
, PURGE_FLAG PURGE_FLAG
, BULK_FLAG BULK_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BULK_FILE_SUB_ID BULK_FILE_SUB_ID
, CURRENCY_CODE CURRENCY_CODE
, FOOT_NOTE_FLAG FOOT_NOTE_FLAG
, CONTACT_ID CONTACT_ID
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, REP_PERIOD_NUM REP_PERIOD_NUM
FROM "FV"."FV_FACTS_SUBMISSION"