DBA Data[Home] [Help]

APPS.CSD_ESTIMATE_UTILS_PVT dependencies on CST_COST_TYPES

Line 1011: FROM cst_item_costs a, cst_cost_types b

1007: -- Cursor to get the item cost for a material item
1008: -- Service validation org is considered here.
1009: CURSOR CUR_MATERIAL_COST(p_item_id NUMBER) IS
1010: SELECT item_cost item_cost
1011: FROM cst_item_costs a, cst_cost_types b
1012: WHERE a.cost_type_id = b.cost_type_id
1013: AND UPPER(b.cost_type) = 'FROZEN'
1014: AND a.inventory_item_id = p_item_id
1015: AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;