APPS.INV_MOVE_ORDER_PUB SQL Statements

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

Line: 107

    x_trohdr_rec.program_update_date := NULL;

Line: 130

    inv_trohdr_util.insert_row(x_trohdr_rec);

Line: 298

 select move_order_type
 from mtl_txn_request_headers h
 where h.header_id = V_header_id;

Line: 303

 select h.order_number , l.org_id -- 6689912 added org_id
 from oe_order_headers_all h
     ,oe_order_lines_all l
 where l.header_id = h.header_id
 and l.line_id = V_line_id;

Line: 316

 SELECT locator_type
   FROM mtl_secondary_inventories
  WHERE organization_id = v_org_id
    AND secondary_inventory_name = v_sub_code;

Line: 324

 SELECT location_control_code
   FROM mtl_system_items
  WHERE organization_id = v_org_id
    AND inventory_item_id = v_item_id;

Line: 416

          select transaction_source_type_id
                into x_trolin_tbl(l_index).transaction_source_type_id
          from mtl_transaction_types
          where transaction_type_id = x_trolin_tbl(l_index).transaction_type_id;

Line: 433

          SELECT primary_uom_code
              ,nvl(restrict_locators_code,0)
              ,nvl(restrict_subinventories_code,0)
          INTO l_primary_uom_code
              ,l_restrict_locators_code
              ,l_restrict_subinventories_code
          FROM mtl_system_items
          WHERE organization_id = x_trolin_tbl(l_index).organization_id
          AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;

Line: 478

            SELECT primary_uom_code
                ,nvl(restrict_locators_code,0)
                ,nvl(restrict_subinventories_code,0)
            INTO l_primary_uom_code
                ,l_restrict_locators_code
                ,l_restrict_subinventories_code
             FROM mtl_system_items
            WHERE organization_id = x_trolin_tbl(l_index).organization_id
              AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;

Line: 497

               SELECT 'Y'
              INTO l_result
                  FROM DUAL
                 WHERE exists (
                    SELECT secondary_locator
                      FROM mtl_secondary_locators
                     WHERE organization_id = x_trolin_tbl(l_index).organization_id
                       AND secondary_locator = x_trolin_tbl(l_index).to_locator_id
                   AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);

Line: 513

           SELECT 'Y'
              INTO l_result
                   FROM DUAL
                 WHERE exists (
                     SELECT secondary_inventory
                       FROM mtl_item_sub_inventories
                      WHERE organization_id = x_trolin_tbl(l_index).organization_id
                      AND secondary_inventory = x_trolin_tbl(l_index).to_subinventory_code
                      AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);

Line: 538

            SELECT primary_uom_code
                ,nvl(restrict_locators_code,0)
                ,nvl(restrict_subinventories_code,0)
            INTO l_primary_uom_code
                ,l_restrict_locators_code
                ,l_restrict_subinventories_code
             FROM mtl_system_items
            WHERE organization_id = x_trolin_tbl(l_index).organization_id
              AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;

Line: 557

           SELECT 'Y'
              INTO l_result
                   FROM DUAL
                 WHERE exists (
                     SELECT secondary_inventory
                       FROM mtl_item_sub_inventories
                      WHERE organization_id = x_trolin_tbl(l_index).organization_id
                      AND secondary_inventory = x_trolin_tbl(l_index).from_subinventory_code
                      AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);

Line: 678

              WSH_INTERFACE.Update_Shipping_Attributes
                (p_source_code               => 'INV',
                 p_changed_attributes        => l_shipping_attr,
                 x_return_status             => l_return_status
                );

Line: 685

                print_debug('return error from update shipping attributes',l_api_name);

Line: 688

                print_debug('return error from update shipping attributes',l_api_name);

Line: 722

              WSH_INTERFACE.Update_Shipping_Attributes
                (p_source_code               => 'INV',
                 p_changed_attributes        => l_shipping_attr,
                 x_return_status             => l_return_status
                );

Line: 728

                print_debug('return error from update shipping attributes',l_api_name);

Line: 731

                print_debug('return error from update shipping attributes',l_api_name);

Line: 759

            WSH_INTERFACE.Update_Shipping_Attributes
              (p_source_code               => 'INV',
               p_changed_attributes        => l_shipping_attr,
               x_return_status             => l_return_status
              );

Line: 766

              print_debug('return error from update shipping attributes',l_api_name);

Line: 769

              print_debug('return error from update shipping attributes',l_api_name);

Line: 779

        SELECT  MTL_TXN_REQUEST_LINES_S.NEXTVAL
         INTO  x_trolin_tbl(l_index).line_id
        FROM  DUAL;

Line: 785

        x_trolin_tbl(l_index).last_update_date   := SYSDATE;

Line: 786

        x_trolin_tbl(l_index).last_updated_by    := fnd_global.user_id;

Line: 787

        x_trolin_tbl(l_index).last_update_login  := fnd_global.login_id;

Line: 816

        l_new_trolin_tbl(l_count).last_updated_by      := x_trolin_tbl(l_index).last_updated_by;

Line: 817

        l_new_trolin_tbl(l_count).last_update_date      := x_trolin_tbl(l_index).last_update_date;

Line: 818

        l_new_trolin_tbl(l_count).last_update_login      := x_trolin_tbl(l_index).last_update_login;

Line: 826

        l_new_trolin_tbl(l_count).program_update_date := x_trolin_tbl(l_index).program_update_date;

Line: 970

        SELECT  MTL_TXN_REQUEST_LINES_S.NEXTVAL
          INTO  x_trolin_tbl(l_index).line_id
          FROM  DUAL;

Line: 977

        x_trolin_tbl(l_index).last_update_date  := SYSDATE;

Line: 978

        x_trolin_tbl(l_index).last_updated_by   := fnd_global.user_id;

Line: 979

        x_trolin_tbl(l_index).last_update_login := fnd_global.login_id;

Line: 1008

        l_new_trolin_tbl(l_count).last_updated_by               := x_trolin_tbl(l_index).last_updated_by;

Line: 1009

        l_new_trolin_tbl(l_count).last_update_date              := x_trolin_tbl(l_index).last_update_date;

Line: 1010

        l_new_trolin_tbl(l_count).last_update_login             := x_trolin_tbl(l_index).last_update_login;

Line: 1018

        l_new_trolin_tbl(l_count).program_update_date           := x_trolin_tbl(l_index).program_update_date;

Line: 1093

    inv_trolin_util.insert_mo_lines_bulk
                  (p_new_trolin_tbl => l_new_trolin_tbl
                  ,x_return_status => x_return_status);

Line: 1098

    l_new_trolin_tbl.delete;

Line: 1101

       print_debug('return error from INSERT_MO_LINES_BULK',l_api_name);

Line: 1118

        l_trolin_tbl(i).operation := INV_GLOBALS.G_OPR_UPDATE;

Line: 1120

            if (l_trolin_tbl(i).operation = INV_GLOBALS.G_OPR_UPDATE and
        (l_trolin_tbl(i).line_id = FND_API.G_MISS_NUM OR
         l_trolin_tbl(i).line_id is null ) ) then
            --inv_debug.message('update and no line id');

Line: 1133

            select count(*)
            into l_dummy
        from mtl_txn_request_headers
            where header_id = l_trolin_tbl(i).header_id
            and organization_id = l_trolin_tbl(i).organization_id;

Line: 1885

l_api_name                    CONSTANT VARCHAR2(30):= 'Update_Move_Order_line';

Line: 2010

      UPDATE mtl_txn_request_lines SET
       carton_grouping_id = p_carton_grouping_tbl(i)
      WHERE line_id = p_move_order_line_tbl(i);