DBA Data[Home] [Help]

VIEW: FV.FV_INV_SELECTED_DUEDATE_TEMP#

Source

View Text - Preformatted

select INVOICE_ID INVOICE_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, INVOICE_NUM INVOICE_NUM, TERMS_DATE TERMS_DATE, ORG_DUE_DATE ORG_DUE_DATE, NEW_DUE_DATE NEW_DUE_DATE, VENDOR_ID VENDOR_ID, SET_OF_BKS_NAME SET_OF_BKS_NAME, ORG_DISCOUNT_DATE ORG_DISCOUNT_DATE, NEW_DISCOUNT_DATE NEW_DISCOUNT_DATE, ORG_SECOND_DISC_DATE ORG_SECOND_DISC_DATE, NEW_SECOND_DISC_DATE NEW_SECOND_DISC_DATE, ORG_THIRD_DISC_DATE ORG_THIRD_DISC_DATE, NEW_THIRD_DISC_DATE NEW_THIRD_DISC_DATE from "FV"."FV_INV_SELECTED_DUEDATE_TEMP"
View Text - HTML Formatted

SELECT INVOICE_ID INVOICE_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, INVOICE_NUM INVOICE_NUM
, TERMS_DATE TERMS_DATE
, ORG_DUE_DATE ORG_DUE_DATE
, NEW_DUE_DATE NEW_DUE_DATE
, VENDOR_ID VENDOR_ID
, SET_OF_BKS_NAME SET_OF_BKS_NAME
, ORG_DISCOUNT_DATE ORG_DISCOUNT_DATE
, NEW_DISCOUNT_DATE NEW_DISCOUNT_DATE
, ORG_SECOND_DISC_DATE ORG_SECOND_DISC_DATE
, NEW_SECOND_DISC_DATE NEW_SECOND_DISC_DATE
, ORG_THIRD_DISC_DATE ORG_THIRD_DISC_DATE
, NEW_THIRD_DISC_DATE NEW_THIRD_DISC_DATE
FROM "FV"."FV_INV_SELECTED_DUEDATE_TEMP"