VIEW: INV.MTL_PAC_ACT_CST_DTL_TEMP#

Source

View Text - Preformatted

select COST_GROUP_ID COST_GROUP_ID, TRANSACTION_ID TRANSACTION_ID, PAC_PERIOD_ID PAC_PERIOD_ID, COST_TYPE_ID COST_TYPE_ID, COST_ELEMENT_ID COST_ELEMENT_ID, LEVEL_TYPE LEVEL_TYPE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, COST_LAYER_ID COST_LAYER_ID, PRIOR_COST PRIOR_COST, ACTUAL_COST ACTUAL_COST, NEW_COST NEW_COST, PRIOR_BUY_COST PRIOR_BUY_COST, PRIOR_MAKE_COST PRIOR_MAKE_COST, NEW_BUY_COST NEW_BUY_COST, NEW_MAKE_COST NEW_MAKE_COST, USER_ENTERED USER_ENTERED, INSERTION_FLAG INSERTION_FLAG, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE, NEW_ONHAND_QUANTITY NEW_ONHAND_QUANTITY, NEW_BUY_QUANTITY NEW_BUY_QUANTITY, NEW_MAKE_QUANTITY NEW_MAKE_QUANTITY, SHIPMENT_NUMBER SHIPMENT_NUMBER, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_COST TRANSPORTATION_COST, MOH_ABSORPTION_COST MOH_ABSORPTION_COST, VARIANCE_AMOUNT VARIANCE_AMOUNT, WIP_VARIANCE WIP_VARIANCE from "INV"."MTL_PAC_ACT_CST_DTL_TEMP"

View Text - HTML Formatted

SELECT COST_GROUP_ID COST_GROUP_ID
, TRANSACTION_ID TRANSACTION_ID
, PAC_PERIOD_ID PAC_PERIOD_ID
, COST_TYPE_ID COST_TYPE_ID
, COST_ELEMENT_ID COST_ELEMENT_ID
, LEVEL_TYPE LEVEL_TYPE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, COST_LAYER_ID COST_LAYER_ID
, PRIOR_COST PRIOR_COST
, ACTUAL_COST ACTUAL_COST
, NEW_COST NEW_COST
, PRIOR_BUY_COST PRIOR_BUY_COST
, PRIOR_MAKE_COST PRIOR_MAKE_COST
, NEW_BUY_COST NEW_BUY_COST
, NEW_MAKE_COST NEW_MAKE_COST
, USER_ENTERED USER_ENTERED
, INSERTION_FLAG INSERTION_FLAG
, TRANSACTION_COSTED_DATE TRANSACTION_COSTED_DATE
, NEW_ONHAND_QUANTITY NEW_ONHAND_QUANTITY
, NEW_BUY_QUANTITY NEW_BUY_QUANTITY
, NEW_MAKE_QUANTITY NEW_MAKE_QUANTITY
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_COST TRANSPORTATION_COST
, MOH_ABSORPTION_COST MOH_ABSORPTION_COST
, VARIANCE_AMOUNT VARIANCE_AMOUNT
, WIP_VARIANCE WIP_VARIANCE
FROM "INV"."MTL_PAC_ACT_CST_DTL_TEMP"