eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: GMF.GMF_LC_LOT_COST_ADJS#

Source

View Text - Preformatted


select LC_ADJUSTMENT_ID LC_ADJUSTMENT_ID, ADJ_TRANSACTION_ID ADJ_TRANSACTION_ID, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY, COSTED_QUANTITY COSTED_QUANTITY, TOTAL_QUANTITY TOTAL_QUANTITY, QUANTITY_UOM_CODE QUANTITY_UOM_CODE, UNIT_BASE_PRICE UNIT_BASE_PRICE, BASE_AMOUNT BASE_AMOUNT, TRANS_AMOUNT TRANS_AMOUNT, BASE_ADJ_AMOUNT BASE_ADJ_AMOUNT, TRANS_ADJ_AMOUNT TRANS_ADJ_AMOUNT, COST_TYPE_ID COST_TYPE_ID, LOT_NUMBER LOT_NUMBER, LOT_COSTED_FLAG LOT_COSTED_FLAG, ONHAND_QUANTITY ONHAND_QUANTITY, OLD_COST_HEADER_ID OLD_COST_HEADER_ID, NEW_COST_HEADER_ID NEW_COST_HEADER_ID, ACCOUNTED_FLAG ACCOUNTED_FLAG, FINAL_POSTING_DATE FINAL_POSTING_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UDPATE_DATE PROGRAM_UDPATE_DATE from "GMF"."GMF_LC_LOT_COST_ADJS"

View Text - HTML Formatted

SELECT LC_ADJUSTMENT_ID LC_ADJUSTMENT_ID
, ADJ_TRANSACTION_ID ADJ_TRANSACTION_ID
, ADJUSTMENT_QUANTITY ADJUSTMENT_QUANTITY
, COSTED_QUANTITY COSTED_QUANTITY
, TOTAL_QUANTITY TOTAL_QUANTITY
, QUANTITY_UOM_CODE QUANTITY_UOM_CODE
, UNIT_BASE_PRICE UNIT_BASE_PRICE
, BASE_AMOUNT BASE_AMOUNT
, TRANS_AMOUNT TRANS_AMOUNT
, BASE_ADJ_AMOUNT BASE_ADJ_AMOUNT
, TRANS_ADJ_AMOUNT TRANS_ADJ_AMOUNT
, COST_TYPE_ID COST_TYPE_ID
, LOT_NUMBER LOT_NUMBER
, LOT_COSTED_FLAG LOT_COSTED_FLAG
, ONHAND_QUANTITY ONHAND_QUANTITY
, OLD_COST_HEADER_ID OLD_COST_HEADER_ID
, NEW_COST_HEADER_ID NEW_COST_HEADER_ID
, ACCOUNTED_FLAG ACCOUNTED_FLAG
, FINAL_POSTING_DATE FINAL_POSTING_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UDPATE_DATE PROGRAM_UDPATE_DATE
FROM "GMF"."GMF_LC_LOT_COST_ADJS"