VIEW: GMF.GMF_LC_ACTUAL_COST_ADJS#

Source

View Text - Preformatted

select AC_ADJUSTMENT_ID AC_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, ADJUSTMENT_STATUS ADJUSTMENT_STATUS, OUT_OF_PERIOD_IND OUT_OF_PERIOD_IND, PERIOD_ID PERIOD_ID, COST_TYPE_ID COST_TYPE_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_ACTUAL_COST_ADJS"

View Text - HTML Formatted

SELECT AC_ADJUSTMENT_ID AC_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
, ADJUSTMENT_STATUS ADJUSTMENT_STATUS
, OUT_OF_PERIOD_IND OUT_OF_PERIOD_IND
, PERIOD_ID PERIOD_ID
, COST_TYPE_ID COST_TYPE_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_ACTUAL_COST_ADJS"