APPS.ONT_OEXOEITR_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 495: from mtl_system_items_vl sitems

491: if (item_identifier_type is null or item_identifier_type = 'INT')
492: or (P_PRINT_DESCRIPTION in ('I','D','F')) then
493: select sitems.description description
494: into v_description
495: from mtl_system_items_vl sitems
496: -- where sitems.customer_order_enabled_flag = 'Y'
497: -- and sitems.bom_item_type in (1,4)
498: where nvl(sitems.organization_id,0) = c_master_org
499: and sitems.inventory_item_id = inventory_item_id_T;

Line 519: mtl_system_items_vl sitems

515: nvl(citems.customer_item_desc,sitems.description) description
516: into v_item,v_description
517: from mtl_customer_items citems,
518: mtl_customer_item_xrefs cxref,
519: mtl_system_items_vl sitems
520: where citems.customer_item_id = cxref.customer_item_id
521: and cxref.inventory_item_id = sitems.inventory_item_id
522: and citems.customer_item_id = ordered_item_id
523: and nvl(sitems.organization_id,0) = c_master_org

Line 534: mtl_system_items_vl sitems

530: nvl(items.description,sitems.description) description
531: into v_item,v_description
532: from mtl_cross_reference_types xtypes,
533: mtl_cross_references items,
534: mtl_system_items_vl sitems
535: where xtypes.cross_reference_type = items.cross_reference_type
536: and items.inventory_item_id = sitems.inventory_item_id
537: and items.cross_reference = ordered_item
538: and items.cross_reference_type = item_identifier_type

Line 552: mtl_system_items_vl sitems

548: nvl(items.description,sitems.description) description
549: into v_item,v_description
550: from mtl_cross_reference_types xtypes,
551: mtl_cross_references items,
552: mtl_system_items_vl sitems
553: where xtypes.cross_reference_type =
554: items.cross_reference_type
555: and items.inventory_item_id =
556: sitems.inventory_item_id