DBA Data[Home] [Help]

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on MTL_SYSTEM_ITEMS

Line 249: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

245: round(nvl(cst.item_cost,0), l_rounding_factor),
246: round(nvl(cst.item_cost,0)/l_min_acct_unit)
247: * l_min_acct_unit)
248: into l_price
249: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
250: where mtl.inventory_item_id = l_item_tbl(l_index)
251: and cst.inventory_item_id (+)=mtl.inventory_item_id
252: and cst.organization_id (+)= nvl(p_costorg_id,mtl.organization_id)
253: and mtl.organization_id = p_organization_id;

Line 264: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

260: -1,
261: round(nvl(cst.item_cost,0), l_rounding_factor),
262: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
263: Into l_price
264: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
265: where mtl.inventory_item_id = l_item_tbl(l_index)
266: and cst.inventory_item_id =mtl.inventory_item_id
267: and cst.organization_id = mtl.organization_id
268: and mtl.organization_id = p_organization_id;

Line 275: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

271: -1,
272: round(nvl(cst.item_cost,0), l_rounding_factor),
273: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
274: Into l_price
275: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
276: where mtl.inventory_item_id = l_item_tbl(l_index)
277: and cst.inventory_item_id =mtl.inventory_item_id
278: and cst.organization_id = p_costorg_id
279: and mtl.organization_id = p_organization_id;

Line 291: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

287: -1,
288: nvl(cst.item_cost,0),
289: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
290: Into l_price
291: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
292: where mtl.inventory_item_id = l_item_tbl(l_index)
293: and cst.inventory_item_id =mtl.inventory_item_id
294: and cst.organization_id = mtl.organization_id
295: and mtl.organization_id = p_organization_id;

Line 303: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

299: -1,
300: nvl(cst.item_cost,0),
301: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
302: Into l_price
303: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
304: where mtl.inventory_item_id = l_item_tbl(l_index)
305: and cst.inventory_item_id =mtl.inventory_item_id
306: and cst.organization_id = p_costorg_id
307: and mtl.organization_id = p_organization_id;

Line 319: from mtl_system_items mtl

315:
316:
317: select mtl.primary_uom_code
318: into l_uom
319: from mtl_system_items mtl
320: where mtl.inventory_item_id = l_item_tbl(l_index)
321: and mtl.organization_id = p_organization_id;
322:
323: select qp_list_lines_s.nextval

Line 489: from mtl_system_items mtl

485: ELSE
486:
487: select mtl.primary_uom_code
488: into l_uom
489: from mtl_system_items mtl
490: where mtl.inventory_item_id = l_item_tbl(l_index)
491: and mtl.organization_id = p_organization_id;
492:
493: