DBA Data[Home] [Help]

APPS.CST_MGD_INFL_ADJUSTMENT_PVT dependencies on MTL_PER_CLOSE_DTLS

Line 448: FROM mtl_per_close_dtls

444: AND acct_period_id = l_prev_org_acct_period_id
445: AND cost_group_id = NVL(p_cost_group_id,cost_group_id)
446: UNION ALL
447: SELECT period_end_quantity, period_end_unit_cost
448: FROM mtl_per_close_dtls
449: WHERE organization_id = p_organization_id
450: AND inventory_item_id = p_inventory_item_id
451: AND acct_period_id = l_prev_org_acct_period_id
452: AND cost_group_id = NVL(p_cost_group_id,cost_group_id)

Line 2873: FROM mtl_per_close_dtls

2869: AND Inventory_Item_ID = c_inv_item_id
2870: AND Cost_Group_ID = NVL(c_cost_group_id,Cost_Group_ID)
2871: UNION ALL
2872: SELECT period_end_quantity, period_end_unit_cost
2873: FROM mtl_per_close_dtls
2874: WHERE Organization_ID = c_org_id
2875: AND Acct_Period_ID = c_acct_period_id
2876: AND Inventory_Item_ID = c_inv_item_id
2877: AND Cost_Group_ID = NVL(c_cost_group_id,Cost_Group_ID)