select  cpp.period_name       期间名称, ccga.organization_id  组织ID, ood.ORGANIZATION_CODE 组织代码, OOD.ORGANIZATION_NAME 组织名称, msib.inventory_item_id 物料ID, msib.segment1 物料编码, msib.description 物料名称, msib.primary_uom_code 单位, cppb.txn_category 类型, cppb.txn_category_qty 数量, round(decode(cppb.txn_category_qty, 0, 0,cppb.txn_category_value / cppb.txn_category_qty),5) 单位成本, round(cppb.txn_category_value,2) 金额, cppb.period_quantity 期间数量, cppb.periodic_cost 期间成本, round(cppb.period_balance,2) 期间金额, round(cppb.variance_amount,2) 差异  from cst_pac_period_balances      cppb,       mtl_system_items_b           msib,       cst_pac_periods              cpp,       cst_cost_groups              ccg,       cst_cost_group_assignments   ccga,       org_organization_definitions ood where cppb.inventory_item_id = msib.inventory_item_id   and msib.organization_id = ccga.organization_id   and cpp.period_name = '&period_name'  and ood.ORGANIZATION_CODE=nvl('&organization_code',ood.ORGANIZATION_CODE)  and msib.segment1='&item_code'  and ood.OPERATING_UNIT=nvl('&ou_id',ood.OPERATING_UNIT)   and cpp.pac_period_id = cppb.pac_period_id   and ccg.cost_group_id = cppb.cost_group_id   and ccg.cost_group_id = ccga.cost_group_id   and ood.ORGANIZATION_ID = ccga.organization_id;