DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on CST_PERIOD_CLOSE_SUMMARY

Line 441: FROM cst_period_close_summary

437: , l_previous_cost
438: FROM (
439: SELECT rollback_quantity period_end_quantity,
440: decode(rollback_quantity,0,0,rollback_value/rollback_quantity) period_end_unit_cost
441: FROM cst_period_close_summary
442: WHERE organization_id = p_organization_id
443: AND inventory_item_id = p_inventory_item_id
444: AND acct_period_id = l_prev_org_acct_period_id
445: AND cost_group_id = NVL(p_cost_group_id,cost_group_id)

Line 2866: FROM cst_period_close_summary

2862: DECODE(SUM(NVL(ABS(Period_End_Quantity), 1)), 0, 1, SUM(NVL(ABS(Period_End_Quantity), 1)))
2863: FROM (
2864: SELECT rollback_quantity period_end_quantity,
2865: decode(rollback_quantity,0,0,rollback_value/rollback_quantity) period_end_unit_cost
2866: FROM cst_period_close_summary
2867: WHERE Organization_ID = c_org_id
2868: AND Acct_Period_ID = c_acct_period_id
2869: AND Inventory_Item_ID = c_inv_item_id
2870: AND Cost_Group_ID = NVL(c_cost_group_id,Cost_Group_ID)