APPS.ONT_OEXOEORS_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 737: from mtl_system_items_vl sitems

733: sitems.description description
734: into
735: -- v_item,
736: v_description
737: from mtl_system_items_vl sitems
738: where
739: sitems.customer_order_enabled_flag = 'Y' and
740: sitems.bom_item_type in (1,4)
741: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)

Line 750: mtl_system_items_vl sitems

746: nvl(citems.customer_item_desc,sitems.description) description
747: into v_item,v_description
748: from mtl_customer_items citems,
749: mtl_customer_item_xrefs cxref,
750: mtl_system_items_vl sitems
751: where citems.customer_item_id = cxref.customer_item_id
752: and cxref.inventory_item_id = sitems.inventory_item_id
753: and citems.customer_item_id = ordered_item_id
754: and nvl(sitems.organization_id,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID',MO_GLOBAL.GET_CURRENT_ORG_ID),0)

Line 765: mtl_system_items_vl sitems

761: nvl(items.description,sitems.description) description
762: into v_item,v_description
763: from mtl_cross_reference_types xtypes,
764: mtl_cross_references items,
765: mtl_system_items_vl sitems
766: where xtypes.cross_reference_type = items.cross_reference_type
767: and items.inventory_item_id = sitems.inventory_item_id
768: and items.cross_reference = ordered_item
769: and items.cross_reference_type = item_identifier_type

Line 783: mtl_system_items_vl sitems

779: nvl(items.description,sitems.description) description
780: into v_item,v_description
781: from mtl_cross_reference_types xtypes,
782: mtl_cross_references items,
783: mtl_system_items_vl sitems
784: where xtypes.cross_reference_type =
785: items.cross_reference_type
786: and items.inventory_item_id = sitems.inventory_item_id
787: and items.cross_reference = ordered_item