CST_STD_APPROVED_COST_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
COST_ORG_ID COST_BOOK_ID VAL_UNIT_ID INVENTORY_ITEM_ID INVENTORY_ORG_ID PRIOR_UNIT_COST

Query

SQL_Statement

SELECT cst.cost_org_id cost_org_id, cst.cost_book_id cost_book_id, cst.val_unit_id val_unit_id, cst.inventory_item_id inventory_item_id, cst.inventory_org_id inventory_org_id, cst.total_cost prior_unit_cost FROM CST_STD_COSTS cst WHERE STATUS_CODE='APPROVED' AND EFFECTIVE_START_DATE = (SELECT MAX(EFFECTIVE_START_DATE) FROM CST_STD_COSTS cst_c WHERE cst_c.cost_org_id = cst.cost_org_id AND cst_c.cost_book_id = cst.cost_book_id AND cst_c.val_unit_id = cst.val_unit_id AND cst_c.inventory_item_id = cst.inventory_item_id AND cst_c.inventory_org_id = cst.inventory_org_id AND cst_c.STATUS_CODE='APPROVED' )