DBA Data[Home] [Help]

APPS.CSTPPCAT dependencies on CST_ITEM_COST_DETAILS

Line 46: from cst_item_cost_details

42: * valuation cost type.
43: */
44: select count(*)
45: into row_count
46: from cst_item_cost_details
47: where organization_id = I_ORGANIZATION_ID
48: and inventory_item_id = I_INVENTORY_ITEM_ID
49: and cost_type_id = p_cost_method
50: and (level_type = 2

Line 67: from cst_item_cost_details

63: * average rates cost type.
64: */
65: select count(*)
66: into row_count
67: from cst_item_cost_details
68: where organization_id = I_ORGANIZATION_ID
69: and inventory_item_id = I_INVENTORY_ITEM_ID
70: and cost_type_id = p_avg_rates_cost_type
71: and NOT (level_type = 1

Line 156: from cst_item_cost_details

152: /*
153: * delete all previously existing costs
154: */
155: delete
156: from cst_item_cost_details
157: where organization_id = I_ORGANIZATION_ID
158: and inventory_item_id = I_INVENTORY_ITEM_ID
159: and cost_type_id = p_cost_method;
160: