DBA Data[Home] [Help]

APPS.CST_ITEMRESOURCECOSTS_GRP dependencies on CST_ITEM_COSTS

Line 118: -- return the item cost from cst_item_costs for the provided combination of inputs

114: where organization_id = p_organization_id;
115: end if;
116:
117: if (p_cost_source = 1 OR p_cost_source = 2) then
118: -- return the item cost from cst_item_costs for the provided combination of inputs
119: l_stmt_num := 20;
120:
121: select item_cost
122: into x_item_cost

Line 123: from cst_item_costs

119: l_stmt_num := 20;
120:
121: select item_cost
122: into x_item_cost
123: from cst_item_costs
124: where organization_id = p_organization_id
125: and inventory_item_id = p_item_id
126: and cost_type_id = l_cost_type_id;
127: