CST_PERPAVG_COST_HEADER_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
TRANSACTION_ID COST_ORG_ID COST_ORG_NAME COST_BOOK_ID COST_BOOK_CODE INVENTORY_ITEM_ID VAL_UNIT_ID VAL_UNIT_CODE RECEIPT_QUANTITY QUANTITY_ONHAND UOM_CODE VAL_STRUCTURE_ID VAL_STRUCTURE_CODE TOTAL_UNIT_COST CURRENCY_CODE COST_DATE EFF_DATE

Query

SQL_Statement

SELECT distinct cpc.TRANSACTION_ID, cpc.COST_ORG_ID, hr.name COST_ORG_NAME, cpc.COST_BOOK_ID, cb.cost_book_code COST_BOOK_CODE, cpc.INVENTORY_ITEM_ID, cpc.VAL_UNIT_ID, ValUnitPEO.VAL_UNIT_CODE, (select quantity from cst_transactions ct where ct.transaction_id = cpc.rec_trxn_id) as receipt_quantity, cpc.QUANTITY_ONHAND, cpc.UOM_CODE, vs.val_structure_id VAL_STRUCTURE_ID, vs.val_structure_code VAL_STRUCTURE_CODE, sum(cpc.unit_cost_average) over(partition by cpc.transaction_id order by cpc.cost_date) total_unit_cost, cpc.CURRENCY_CODE currency_code, cpc.COST_DATE cost_Date, cpc.EFF_DATE FROM CST_PERPAVG_COST cpc, hr_organization_units_f_tl hr, cst_cost_books_vl cb, cst_val_structures_b vs, CST_VAL_UNITS_VL ValUnitPEO where cpc.COST_ORG_ID = hr.ORGANIZATION_ID AND hr.LANGUAGE = USERENV('LANG') AND hr.EFFECTIVE_START_DATE <= cpc.COST_DATE AND hr.effective_end_date >= cpc.COST_DATE AND cb.cost_book_id = cpc.COST_BOOK_ID AND cpc.VAL_UNIT_ID = ValUnitPEO.VAL_UNIT_ID AND vs.val_structure_id=ValUnitPEO.val_structure_id