VIEW: BOM.CST_RCV_ACQ_COSTS#

Source

View Text - Preformatted

select HEADER_ID HEADER_ID, COST_GROUP_ID COST_GROUP_ID, COST_TYPE_ID COST_TYPE_ID, PERIOD_ID PERIOD_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, NET_QUANTITY_RECEIVED NET_QUANTITY_RECEIVED, TOTAL_QUANTITY_INVOICED TOTAL_QUANTITY_INVOICED, QUANTITY_AT_PO_PRICE QUANTITY_AT_PO_PRICE, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT, AMOUNT_AT_PO_PRICE AMOUNT_AT_PO_PRICE, TOTAL_AMOUNT TOTAL_AMOUNT, COSTED_QUANTITY COSTED_QUANTITY, ACQUISITION_COST ACQUISITION_COST, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID, PO_UNIT_PRICE PO_UNIT_PRICE, PRIMARY_UOM PRIMARY_UOM, REC_EXCHG_RATE REC_EXCHG_RATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, 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 from "BOM"."CST_RCV_ACQ_COSTS"

View Text - HTML Formatted

SELECT HEADER_ID HEADER_ID
, COST_GROUP_ID COST_GROUP_ID
, COST_TYPE_ID COST_TYPE_ID
, PERIOD_ID PERIOD_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, NET_QUANTITY_RECEIVED NET_QUANTITY_RECEIVED
, TOTAL_QUANTITY_INVOICED TOTAL_QUANTITY_INVOICED
, QUANTITY_AT_PO_PRICE QUANTITY_AT_PO_PRICE
, TOTAL_INVOICE_AMOUNT TOTAL_INVOICE_AMOUNT
, AMOUNT_AT_PO_PRICE AMOUNT_AT_PO_PRICE
, TOTAL_AMOUNT TOTAL_AMOUNT
, COSTED_QUANTITY COSTED_QUANTITY
, ACQUISITION_COST ACQUISITION_COST
, PO_LINE_LOCATION_ID PO_LINE_LOCATION_ID
, PO_UNIT_PRICE PO_UNIT_PRICE
, PRIMARY_UOM PRIMARY_UOM
, REC_EXCHG_RATE REC_EXCHG_RATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, 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
FROM "BOM"."CST_RCV_ACQ_COSTS"