APPS.CSE_DEPLOYMENT_GRP SQL Statements

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

Line: 34

      SELECT instance_asset_id,
             instance_id,
             fa_asset_id,
             fa_book_type_code,
             fa_location_id
      FROM   csi_i_assets
      WHERE  instance_id = p_instance_id
      AND    fa_asset_id = p_asset_id
      AND    asset_quantity > 0
      AND    sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1);

Line: 126

      debug('Operational Update :-');

Line: 128

      SELECT location_type_code,
             operational_status_code,
             instance_usage_code,
             accounting_class_code,
             quantity,
             last_vld_organization_id,
             object_version_number
      INTO   l_location_type_code,
             l_operational_status_code,
             l_instance_usage_code,
             l_accounting_class_code,
             l_quantity,
             l_last_vld_organization_id,
             l_object_version_number
      FROM   csi_item_instances
      WHERE  instance_id = p_instance_id;

Line: 231

      SELECT object_version_number
      INTO   l_u_instance_rec.object_version_number
      FROM   csi_item_instances
      WHERE  instance_id = l_u_instance_rec.instance_id;

Line: 240

      debug('Calling API csi_item_instance_pub.update_item_instance');

Line: 246

      csi_item_instance_pub.update_item_instance(
        p_api_version           => 1.0,
        p_commit                => fnd_api.g_false,
        p_init_msg_list         => fnd_api.g_true,
        p_validation_level      => fnd_api.g_valid_level_full,
        p_instance_rec          => l_u_instance_rec,
        p_party_tbl             => l_u_parties_tbl,
        p_account_tbl           => l_u_pty_accts_tbl,
        p_org_assignments_tbl   => l_u_org_units_tbl,
        p_ext_attrib_values_tbl => l_u_ea_values_tbl,
        p_pricing_attrib_tbl    => l_u_pricing_tbl,
        p_asset_assignment_tbl  => l_u_assets_tbl,
        p_txn_rec               => px_txn_rec,
        x_instance_id_lst       => l_instance_ids_list,
        x_return_status         => l_return_status,
        x_msg_count             => l_msg_count,
        x_msg_data              => l_msg_data);

Line: 537

    SELECT sysdate INTO l_sysdate FROM sys.dual;

Line: 552

        SELECT inventory_item_id,
               last_vld_organization_id,
               serial_number,
               lot_number,
               inventory_revision,
               operational_status_code,
               unit_of_measure,
               pa_project_id,
               pa_project_task_id,
               last_pa_project_id,
               last_pa_task_id,
               owner_party_id,
               owner_party_account_id,
               accounting_class_code,
               location_type_code,
               location_id,
               instance_usage_code,
               operational_status_code
        INTO   l_t_inst_tbl(1).inventory_item_id ,
               l_t_inst_tbl(1).vld_organization_id ,
               l_t_inst_tbl(1).serial_number,
               l_t_inst_tbl(1).lot_number,
               l_t_inst_tbl(1).inventory_revision,
               l_t_inst_tbl(1).operational_status_code,
               l_t_inst_tbl(1).unit_of_measure,
               l_project_id,
               l_task_id,
               l_last_project_id,
               l_last_task_id,
               l_owner_party_id,
               l_owner_party_account_id,
               l_acct_class_code,
               l_location_type_code,
               l_location_id,
               l_instance_usage_code,
               l_operational_status_code
        FROM   csi_item_instances
        WHERE  instance_id = p_instance_tbl(si_ind).instance_id;