DBA Data[Home] [Help]

APPS.ONT_OEXIODIS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 436: from mtl_system_items_vl sitems

432: 'VALUE');
433:
434: select sitems.description description
435: into v_description
436: from mtl_system_items_vl sitems
437: --where sitems.customer_order_enabled_flag = 'Y'
438: where sitems.bom_item_type in (1,4)
439: and nvl(sitems.organization_id,0) = RP_DUMMY_ITEM
440: and sitems.inventory_item_id = item_dspFormula.inventory_item_id;

Line 462: mtl_system_items_vl sitems

458: nvl(citems.customer_item_desc,sitems.description) description
459: into v_item,v_description
460: from mtl_customer_items citems,
461: mtl_customer_item_xrefs cxref,
462: mtl_system_items_vl sitems
463: where citems.customer_item_id = cxref.customer_item_id
464: and cxref.inventory_item_id = sitems.inventory_item_id
465: and citems.customer_item_id = item_dspFormula.ordered_item_id
466: and nvl(sitems.organization_id,0) = RP_DUMMY_ITEM

Line 476: mtl_system_items_vl sitems

472: nvl(items.description,sitems.description) description
473: into v_item,v_description
474: from mtl_cross_reference_types xtypes,
475: mtl_cross_references items,
476: mtl_system_items_vl sitems
477: where xtypes.cross_reference_type = items.cross_reference_type
478: and items.inventory_item_id = sitems.inventory_item_id
479: and items.cross_reference = item_dspFormula.ordered_item
480: and items.cross_reference_type = item_dspFormula.item_identifier_type