SELECT crac.HEADER_ID /*PK*/,
crac.COST_GROUP_ID,
crac.COST_TYPE_ID,
crac.PERIOD_ID,
crac.RCV_TRANSACTION_ID,
crac.NET_QUANTITY_RECEIVED,
crac.TOTAL_QUANTITY_INVOICED,
crac.QUANTITY_AT_PO_PRICE,
crac.TOTAL_INVOICE_AMOUNT,
crac.AMOUNT_AT_PO_PRICE,
crac.TOTAL_AMOUNT,
crac.COSTED_QUANTITY,
crac.ACQUISITION_COST,
crac.PO_UNIT_PRICE,
crac.PRIMARY_UOM,
crac.REC_EXCHG_RATE /* FOREIGN KEYS RESOLVED */,
ccg.cost_group,
cct.cost_type,
cpp.period_name,
rt.TRANSACTION_TYPE,
rt.TRANSACTION_DATE /* ID */,
crac.PO_LINE_LOCATION_ID /* WHO */,
crac.creation_date,
crac.created_by,
crac.last_update_date,
crac.last_updated_by
from CST_PAC_PERIODS cpp,
CST_COST_GROUPS ccg,
CST_COST_TYPES
