APPS.OPIMPXWI dependencies on MTL_CST_ACTUAL_COST_DETAILS

Line 76: The mcacd (mtl_cst_actual_cost_details) does not store the

72:
73: Description: Gets the cost for an inventory item in a standard costing org
74: for a given date.
75:
76: The mcacd (mtl_cst_actual_cost_details) does not store the
77: the new cost in the actual_cost column of a transaction ID
78: corresponding to a standard cost update (SCU). When we look
79: up the item cost for an item with a SCU which:
80: 1. Was made prior to the start date of the collection program

Line 259: mtl_cst_actual_cost_details tables. If there is no cost there,

255: avg_costing_org_item_cost
256:
257: Description: Return the item cost for an item in an average costing org.
258: Average costing orgs store the cost in the
259: mtl_cst_actual_cost_details tables. If there is no cost there,
260: then return the cost to be 0.
261:
262: Arguments: p_organization_id - organization id
263: p_item_id - inventory_item_id

Line 290: FROM mtl_cst_actual_cost_details macd,

286: -- affect inventory quantity or balance.
287: -- ltong 01/20/2003. Filtered out consigned inventory.
288: SELECT max (macd.transaction_id)
289: INTO l_trx_id
290: FROM mtl_cst_actual_cost_details macd,
291: mtl_material_transactions mmt
292: WHERE mmt.transaction_id = macd.transaction_id
293: AND mmt.organization_id = p_organization_id
294: AND mmt.inventory_item_id = p_item_id

Line 305: FROM mtl_cst_actual_cost_details mcacd,

301: AND mmt.transaction_date = (
302: SELECT transaction_date
303: FROM
304: (SELECT /*+ first_rows */ mt.transaction_date
305: FROM mtl_cst_actual_cost_details mcacd,
306: mtl_material_transactions mt
307: WHERE mt.transaction_id = mcacd.transaction_id
308: AND mt.transaction_date < p_cost_date + 1
309: AND mt.organization_id = p_organization_id

Line 324: FROM mtl_cst_actual_cost_details macd

320: l_item_cost:=0;
321: ELSE
322: SELECT SUM(macd.new_cost)
323: INTO l_item_cost
324: FROM mtl_cst_actual_cost_details macd
325: WHERE macd.transaction_id = l_trx_id
326: AND macd.organization_id = p_organization_id; /* Bug 3661478 - add filter on organization_id*/
327:
328: END IF; --} l_trx_id is null

Line 2217: FROM mtl_cst_actual_cost_details macd,

2213: -- affect inventory quantity or balance.
2214: -- ltong 01/20/2003. Filtered out consigned inventory.
2215: SELECT MAX(macd.transaction_id)
2216: INTO l_trx_id
2217: FROM mtl_cst_actual_cost_details macd,
2218: mtl_material_transactions mmt
2219: WHERE mmt.transaction_id = macd.transaction_id
2220: AND mmt.ORGANIZATION_ID = Org_id
2221: AND mmt.INVENTORY_ITEM_ID = l_item_id

Line 2233: FROM mtl_cst_actual_cost_details mcacd,

2229: AND mmt.transaction_date =
2230: (SELECT transaction_date
2231: FROM
2232: (SELECT /*+ first_rows */ mt.transaction_date
2233: FROM mtl_cst_actual_cost_details mcacd,
2234: mtl_material_transactions mt
2235: WHERE mt.transaction_id = mcacd.transaction_id
2236: AND mt.TRANSACTION_DATE < Trunc( p_from_date+1)
2237: AND mt.ORGANIZATION_ID = Org_id

Line 2249: FROM mtl_cst_actual_cost_details macd

2245: WHERE rownum = 1);
2246:
2247: SELECT sum(macd.NEW_cost)
2248: INTO item_cost
2249: FROM mtl_cst_actual_cost_details macd
2250: WHERE macd.transaction_id=l_trx_id
2251: AND macd.organization_id = Org_id; /* Bug 3661478 - add filter on organization_id*/
2252:
2253: