VIEW: BOM.CST_AP_VARIANCE_BATCHES#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, ORGANIZATION_ID ORGANIZATION_ID, ITEM_OPTION ITEM_OPTION, INVOICE_PROJECT_OPTION INVOICE_PROJECT_OPTION, ADJUSTMENT_ACCOUNT ADJUSTMENT_ACCOUNT, CUTOFF_DATE CUTOFF_DATE, TRANSACTION_PROCESS_MODE TRANSACTION_PROCESS_MODE, SPECIFIC_ITEM_ID SPECIFIC_ITEM_ID, SPECIFIC_PROJECT_ID SPECIFIC_PROJECT_ID, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DESCRIPTION DESCRIPTION, WIP_ENTITY_ID WIP_ENTITY_ID, ITEM_TYPE ITEM_TYPE from "BOM"."CST_AP_VARIANCE_BATCHES"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, ORGANIZATION_ID ORGANIZATION_ID
, ITEM_OPTION ITEM_OPTION
, INVOICE_PROJECT_OPTION INVOICE_PROJECT_OPTION
, ADJUSTMENT_ACCOUNT ADJUSTMENT_ACCOUNT
, CUTOFF_DATE CUTOFF_DATE
, TRANSACTION_PROCESS_MODE TRANSACTION_PROCESS_MODE
, SPECIFIC_ITEM_ID SPECIFIC_ITEM_ID
, SPECIFIC_PROJECT_ID SPECIFIC_PROJECT_ID
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DESCRIPTION DESCRIPTION
, WIP_ENTITY_ID WIP_ENTITY_ID
, ITEM_TYPE ITEM_TYPE
FROM "BOM"."CST_AP_VARIANCE_BATCHES"