DBA Data[Home] [Help]

APPS.QP_ADD_ITEM_PRCLIST_PVT dependencies on MTL_SYSTEM_ITEMS

Line 274: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

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

Line 290: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

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

Line 343: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

339: -1,
340: round(nvl(cst.item_cost,0), l_rounding_factor),
341: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
342: Into l_price
343: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
344: where mtl.inventory_item_id = l_item_tbl(l_index)
345: and cst.inventory_item_id =mtl.inventory_item_id
346: and cst.organization_id = p_costorg_id
347: and mtl.organization_id = p_organization_id;

Line 362: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

358: -1,
359: nvl(cst.item_cost,0),
360: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
361: Into l_price
362: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
363: where mtl.inventory_item_id = l_item_tbl(l_index)
364: and cst.inventory_item_id =mtl.inventory_item_id
365: and cst.organization_id = mtl.organization_id
366: and mtl.organization_id = p_organization_id;

Line 416: from mtl_system_items mtl, cst_item_costs_for_gl_view cst

412: -1,
413: nvl(cst.item_cost,0),
414: round(nvl(cst.item_cost,0)/l_min_acct_unit)*l_min_acct_unit)
415: Into l_price
416: from mtl_system_items mtl, cst_item_costs_for_gl_view cst
417: where mtl.inventory_item_id = l_item_tbl(l_index)
418: and cst.inventory_item_id =mtl.inventory_item_id
419: and cst.organization_id = p_costorg_id
420: and mtl.organization_id = p_organization_id;

Line 435: from mtl_system_items mtl

431:
432:
433: select mtl.primary_uom_code
434: into l_uom
435: from mtl_system_items mtl
436: where mtl.inventory_item_id = l_item_tbl(l_index)
437: and mtl.organization_id = p_organization_id;
438:
439: select qp_list_lines_s.nextval

Line 614: from mtl_system_items mtl

610: ELSE
611:
612: select mtl.primary_uom_code
613: into l_uom
614: from mtl_system_items mtl
615: where mtl.inventory_item_id = l_item_tbl(l_index)
616: and mtl.organization_id = p_organization_id;
617: -- 10185331
618: SELECT orig_system_header_ref INTO