VIEW: GML.PO_COST_DTL#

Source

View Text - Preformatted

select DOC_TYPE DOC_TYPE, POS_ID POS_ID, LINE_ID LINE_ID, AQUI_COST_ID AQUI_COST_ID, COST_AMOUNT COST_AMOUNT, INCL_IND INCL_IND, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, TEXT_CODE TEXT_CODE, TRANS_CNT TRANS_CNT, DELETE_MARK DELETE_MARK, LINE_LOCATION_ID LINE_LOCATION_ID, MIGRATION_IND MIGRATION_IND, PO_HEADER_ID PO_HEADER_ID, PO_LINE_ID PO_LINE_ID, TOTAL_COST TOTAL_COST, TOTAL_COST_FLAG TOTAL_COST_FLAG, TOTAL_COST_BASIS TOTAL_COST_BASIS from "GML"."PO_COST_DTL"

View Text - HTML Formatted

SELECT DOC_TYPE DOC_TYPE
, POS_ID POS_ID
, LINE_ID LINE_ID
, AQUI_COST_ID AQUI_COST_ID
, COST_AMOUNT COST_AMOUNT
, INCL_IND INCL_IND
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, TEXT_CODE TEXT_CODE
, TRANS_CNT TRANS_CNT
, DELETE_MARK DELETE_MARK
, LINE_LOCATION_ID LINE_LOCATION_ID
, MIGRATION_IND MIGRATION_IND
, PO_HEADER_ID PO_HEADER_ID
, PO_LINE_ID PO_LINE_ID
, TOTAL_COST TOTAL_COST
, TOTAL_COST_FLAG TOTAL_COST_FLAG
, TOTAL_COST_BASIS TOTAL_COST_BASIS
FROM "GML"."PO_COST_DTL"