APPS.OE_ORDER_MISC_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

         SELECT  concatenated_segments
                ,concatenated_segments
                ,description
         INTO x_ordered_item
             ,x_inventory_item
             ,x_ordered_item_desc
         FROM  mtl_system_items_vl
         WHERE inventory_item_id = p_inventory_item_id
         AND organization_id = l_organization_id;

Line: 59

         SELECT citems.customer_item_number
               ,sitems.concatenated_segments
               ,nvl(citems.customer_item_desc, sitems.description)
         INTO  x_ordered_item
              ,x_inventory_item
              ,x_ordered_item_desc
         FROM  mtl_customer_items citems
              ,mtl_customer_item_xrefs cxref
              ,mtl_system_items_vl sitems
         WHERE citems.customer_item_id = cxref.customer_item_id
           AND cxref.inventory_item_id = sitems.inventory_item_id
           AND sitems.inventory_item_id = p_inventory_item_id
           AND sitems.organization_id = l_organization_id
           AND citems.customer_item_id = p_ordered_item_id
           AND citems.customer_id = p_sold_to_org_id;

Line: 77

         SELECT  category_concat_segs
                ,category_concat_segs
                ,description
         INTO x_ordered_item
             ,x_inventory_item
             ,x_ordered_item_desc
         FROM  mtl_categories_v
         WHERE CATEGORY_ID = p_inventory_item_id;

Line: 93

            SELECT   items.cross_reference
                    ,sitems.concatenated_segments
                    ,nvl(items.description, sitems.description)
            INTO   x_ordered_item
                  ,x_inventory_item
                  ,x_ordered_item_desc
            FROM  mtl_cross_reference_types types
              , mtl_cross_references items
              , mtl_system_items_vl sitems
            WHERE types.cross_reference_type = items.cross_reference_type
              AND items.inventory_item_id = sitems.inventory_item_id
              AND sitems.organization_id = l_organization_id
              AND sitems.inventory_item_id = p_inventory_item_id
              AND items.cross_reference_type = p_item_identifier_type
              AND items.cross_reference = p_ordered_item;