APPS.OPIMPXWI dependencies on CST_ITEM_COSTS

Line 21: Description: return the cost for an item/org from the cst_item_costs (cic)

17:
18: /*
19: get_cost_from_cic
20:
21: Description: return the cost for an item/org from the cst_item_costs (cic)
22: table.
23:
24: Parameters IN: p_org_id - organization id
25: p_item_id - inventory_item_id

Line 42: -- Cursor to get the item cost from the CIC (cst_item_costs). If there

38:
39: -- item cost from cic
40: l_item_cost NUMBER; -- no default needed since CIC must have some cost
41:
42: -- Cursor to get the item cost from the CIC (cst_item_costs). If there
43: -- are no cost updates ever on the item, then the CIC stores the most
44: -- historical cost.
45: CURSOR cic_item_cost_cur (p_org_id NUMBER, p_item_id NUMBER)
46: IS

Line 48: FROM cst_item_costs cic

44: -- historical cost.
45: CURSOR cic_item_cost_cur (p_org_id NUMBER, p_item_id NUMBER)
46: IS
47: SELECT cic.item_cost item_cost
48: FROM cst_item_costs cic
49: WHERE cic.organization_id = p_org_id
50: AND cic.inventory_item_id = p_item_id
51: and cost_type_id=1;
52:

Line 95: because the cic (cst_item_costs) no longer has the

91: cost on that day.
92: 2. If csc is has no data prior to the start date, but has data
93: after the start date,
94: ----Then use the cost in the mmt (mtl_material_transactions)
95: because the cic (cst_item_costs) no longer has the
96: historical cost.
97: ----Else use the cost in the CIC
98:
99: Parameters IN: p_org_id - standard costing organization_id