VIEW: BOM.CST_AP_VARIANCE_LINES#

Source

View Text - Preformatted

select VARIANCE_HEADER_ID VARIANCE_HEADER_ID, VARIANCE_LINE_ID VARIANCE_LINE_ID, BATCH_ID BATCH_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, INVOICE_ID INVOICE_ID, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE, VAR_AMOUNT VAR_AMOUNT, PROJECT_ID PROJECT_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_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, COST_GROUP_ID COST_GROUP_ID from "BOM"."CST_AP_VARIANCE_LINES"

View Text - HTML Formatted

SELECT VARIANCE_HEADER_ID VARIANCE_HEADER_ID
, VARIANCE_LINE_ID VARIANCE_LINE_ID
, BATCH_ID BATCH_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, INVOICE_ID INVOICE_ID
, DISTRIBUTION_LINE_NUMBER DISTRIBUTION_LINE_NUMBER
, PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, INVOICE_PRICE_VARIANCE INVOICE_PRICE_VARIANCE
, BASE_INVOICE_PRICE_VARIANCE BASE_INVOICE_PRICE_VARIANCE
, VAR_AMOUNT VAR_AMOUNT
, PROJECT_ID PROJECT_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_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
, COST_GROUP_ID COST_GROUP_ID
FROM "BOM"."CST_AP_VARIANCE_LINES"