CST_R_PERPAVG_COST_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID TRANSACTION_ID REC_TRXN_ID VAL_UNIT_ID INVENTORY_ITEM_ID UNIT_COST_AVERAGE COST_ELEMENT_ID CURRENCY_CODE COST_DATE EFF_DATE GL_DATE

Query

SQL_Statement

select cpc.cost_org_id, cpc.cost_book_id, cpc.transaction_id, cpc.rec_trxn_id, cpc.val_unit_id, cpc.inventory_item_id, cpc.unit_cost_average, cpc.cost_element_id, cpc.currency_code, cpc.cost_date, cpc.eff_date, ccd.gl_date from cst_perpavg_cost cpc, cst_layer_costs ci, cst_cost_distributions ccd where ci.rec_trxn_id = cpc.rec_trxn_id and ci.dep_trxn_id = 0 and ci.distribution_id = ccd.distribution_id and ci.cost_element_id = cpc.cost_element_id and ci.eff_date = cpc.eff_date and ccd.accounted_flag = 'F'